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

[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

 

[John Gilson]

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

SELECT DISTINCT LastName, FirstName
FROM T

Regards,
jag

 

[Don]

SELECT DISTINCT LastName, FirstName
FROM T

Regards,
jag

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