Thank you for the help everyone! I think Sean's looks the most efficient, as that will only run the sub-query once.
Now that I know how to use this trick, I think I could use this in quite a few other places too ;-) >Try: >SELECT > T.ID > T.GroupID > T2.FKCode > T2.Value >FROM ( > select MIN (ID) as ID, GroupID > from MyTable > GROUP BY GroupID > ) T > JOIN MyTable T2 ON T2.ID = T.ID > >Sean
