>>>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
>

>
>?

This sounds correct to me as well.