Select distinct

[Paul-NYS]

Hi


I am trying to run a query that queries and returns several data fields with one of them being an ID field. I want to select distinct IDs only, however, I don't think just adding a 'distinct' qualifier prior the ID field will do it--the only field that I want to be distinct is the ID, the others it doesn't matter.

Does anyone know how to add a 'distinct' qualifier to a query that just applies to one field only (the ID field)?

Select distinct ID, firstName, lastName, DOB, City from Person where City = "NYC";

Paul

[jzwp11]

Is the ID field the primary key field of the table? If so, then all values would have to be unique. If it is not the primary key, then you would probably have to use an aggregate query to group by that ID field, but that would force you to use one of the aggregate functions. If you have several records with the same ID, which of those particular records do you want to show?