[SQL User Wannabe] Extracting Distinct Records Based on Two Fields

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I am trying to develop a query which will report records with a unique pair
of fields. Probably better explained using a simple example:

LastName FirstName
Dog Big
Cat Fat
Mouse Sqweeky
Dog Alpha
Dog Big

Running the query would result in:

Dog Big
Cat Fat
Mouse Sqweeky
Dog Alpha

There are other fields in the record that need to be ignored.

Any suggestions?

Thanks!

Don
 
Don said:
I am trying to develop a query which will report records with a unique pair
of fields. Probably better explained using a simple example:

LastName FirstName
Dog Big
Cat Fat
Mouse Sqweeky
Dog Alpha
Dog Big

Running the query would result in:

Dog Big
Cat Fat
Mouse Sqweeky
Dog Alpha

There are other fields in the record that need to be ignored.

Any suggestions?

Thanks!

Don
Click to expand...

SELECT DISTINCT LastName, FirstName
FROM T

Regards,
jag
 
John Gilson said:
SELECT DISTINCT LastName, FirstName
FROM T

Regards,
jag
Click to expand...

John,

Thanks!

Is there any way to include the remaining fields from the record? Would the
"SELECT DISTINCT" become a sub-query of a primary query that includes all
the fields from the record?

Thanks again!

Don
 
Back
Top