boxhead — 2010-12-31T05:41:09-05:00 — #1
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?
guido2004 — 2010-12-31T05:45:54-05:00 — #2
SELECT COUNT(DISTINCT Table.RecordID) AS UniqueRecordCount
WHERE Table.Bool = 0
boxhead — 2010-12-31T05:53:23-05:00 — #3
2 people, 2 days - every combination except that one!!
Thanks muchly - we are busy kicking ourselves in the office! :rofl:
guido2004 — 2010-12-31T05:55:55-05:00 — #4
Don't kick too hard... there's a party tonight!