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

?