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?