Select distinct

[Mr. Bart Pietercil]

Hi List, Ruslan

struggling with this query which seems simple enough

the query

select distinct name from tbl_indicators returns the records I want.
However in this selection I want to see all fields from the table so I  
(mistakenly) thought I could do

select distinct name, recid from tbl_indicators

but this returns all records. I can see why but I don't see how I can  
resolve my problem


Bart