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