Select Distinct Help

I need to use a Select Distinct statement however, I notice you can only return one field; such as:

SELECT DISTINCT airport;

Does return only one rec per airport - however I need access to the other fields and would like to say:

SELECT DISTINCT airport, id;

but while both fields get returned, the records are not distinct.

How can I make this work?

Thanks...

DISTINCT won't work on a single column; it affects the entire row returned. If each airport has more than one id, how do you want to determine which id to match it?