I have a custom file with three fields in it. All three fields are part of the primary key. I have a selects built that are working but they return all records. Is there a way to return only the distinct list of the first field. So My table has Group, company, and location in it. Currently my selects return every combination in the table. I want to return only a distinct list of group names.
So instead of Group1, company1, location1 Group1, company1, location2 Group2, ......
I want Group1 Group2 Thanks, Alex