Selecting distinct rows

[pbeast]

Is it possible to select distinct rows from 1 table
table data looks like:

400000,george,washington
400000,george,washington
400001,thomas,jefferson


i have 5000 rows - but only want to select distinct rows by the first column - so from the data above i would only select:

400000,george,washington
400001,thomas,jefferson

Thanks.

 

[PHV]

Have a look at the DISTINCT predicate:
SELECT DISTINCT ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[pbeast]

Ah thanks. But, i'm using MS access and its not letting me use that statement correctly - unless i'm doing something wrong. I'll figure out another way to get the values. Thanks.

 

[PHV]

I gave you SQL code advice, so go to the SQL view ...

 

[pbeast]

ok. thanks.