Show Records Where All Related Records Are False

  • Thread starter Thread starter Cliff
  • Start date Start date
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
 
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
 
Back
Top