this seems to be more a sort of SQL question. the thing is you say "but does not include the rest of the columns". What do you expect to see there? if there are two rows with identical values in Field1, but different values in Field2, how should your result look like?