need SQL help

[Ph00]

how do i build a query that will return all unique values (no duplicates) in a non unique column... the column that needs to be quereyd cant be set to unique either

 

[Croda]

Have you tried:

SELECT DISTINCT(FieldName) FROM

???

Sorry if that's too simple.

 

[Ph00]

<< Have you tried:

SELECT DISTINCT(FieldName) FROM

???

Sorry if that's too simple. >>




it worked perfectly thanks..

 

[Brian07]

Select
Distinct/Unique(fieldname)
From
table

where
this=that