[RESOLVED] SQL "select distinct"

[met0555]

Hi,

I have a table with 3 columns, name,number,active . I only want to select unique (name, number) where active=false. I tried to accomplish the following with

SELECT DISTINCT name, number
FROM Table1
WHERE active=false

However, I feel like my query is only looking for the distinct results between the records where active=false. But I want the distinct to check that the records are unique inside the whole table no matter what the active columns says, and display the distinct results of rows with active=false .

Please let me know what I am missing.


Thanks