Count unique records

[boxhead]

I have a table where each row contains a boolean and a foreign key to another trecord in another table.

I want to know how many distinct foreign keys have false as the boolean - something like this:

SELECT  COUNT(
	SELECT	DISTINCT Table.RecordID
	FROM	Table
             WHERE Table.Bool = 0)
 AS UniqueRecordCount

how would i achieve this?

cheers

monkey

[guido2004]

SELECT  COUNT(DISTINCT Table.RecordID) AS UniqueRecordCount
FROM	Table
WHERE Table.Bool = 0

[boxhead]

SELECT  COUNT(DISTINCT Table.RecordID) AS UniqueRecordCount
FROM	Table
WHERE Table.Bool = 0

2 people, 2 days - every combination except that one!!

Thanks muchly - we are busy kicking ourselves in the office!

[guido2004]

Don't kick too hard... there's a party tonight!