select pkfield, table1.anotherfield, 
 ( SELECT max(field2) from table1 t12 where t11.pkfield = t12.pkfield) as maxfield 
from table1 t11

>Hi Fred
>
>I really must have two consecutive SQLs as I need MaxField in the final output. Your answer was right, since I asked the wrong question! The second SQL should have been ...
>
<snip>