Show Records Where All Related Records Are False

C

Cliff

In a one-to-many table relationship, I need to show only records from the
primary table where a boolean field is False in ALL related records. It
seems simple but my knowledge of SQL is a little weak. Thanks for your help.

Mike
 
C

Cliff

I created a subquery where the boolean field criterium was False and
left-joined it to the main query having criteria for the boolean field in
the main query as True and the ID field of the subquery as Is Null (grouped
by ID field). I THINK I explained that right. ;-)

Thanks,
Mike
 
Top