>WHERE NOT EXISTS (SELECT 1 FROM ManyToManyTable > INNER JOIN ChildTable ON ManyToManyTable.NoChildTable=ChildTable.Numero > WHERE Master.Numero=ManyToManyTable.NoMaster > AND ChildTable.Enabled <> 1 ) >Thanks, but I still get unwanted master records having some Enabled=0 child records.