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>
--sb--