Ops.. so much buggy help attemt.. :)

select y.grpfield, max(y.valuefield) from wt1 x
join t1 y on y.id=x.id
group by 1