>>I'm not sure I'm following you but try
>>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.
You want to get records if ALL child records are Enabled = 0, isn't it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
