>>You want to get records if ALL child records are Enabled = 0, isn't it?
>
>Pretty much, except the condition is in reversed. But, that is not a factor here. It is just a question of the syntax.
SELECT *
FROM MasterTable
INNER JOIN ChildTable ON MasterTable.PK = ChildTable.FK
INNER JOIN (SELECT ChildTable.FK
SUM(CASE WHEN The Condition goes Here
THEN 1
ELSE 0 END) AS CondRecs,
COUNT(*) AS AllRecs
FROM ChildTable
GROUP BY FK) Tbl1
ON MasterTable.PK = ChildTable.FK AND
ChildTable.CondRecs = ChildTable.AllRecs
?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.