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 DISTINCT Table.RecordID
WHERE Table.Bool = 0)
how would i achieve this?
SELECT COUNT(DISTINCT Table.RecordID) AS UniqueRecordCount
WHERE Table.Bool = 0
2 people, 2 days - every combination except that one!!
Thanks muchly - we are busy kicking ourselves in the office! :rofl:
Don't kick too hard... there's a party tonight!