I've just tried

select * from temptable t where (t.ID,t.PROGDATE)

in (select id,min(progdate) from temptable group by(id))

but get SQL error msg

"Incorrect syntax near ',' line 1"