依靠数字技巧(其中父子链接的数量=子代的数量,该父代链接到所有子代):
SELECt Parent.ParentID, COUNT(*)FROM ParentINNER JOIN ChildParent ON ChildParent.ParentID = Parent.ParentIDINNER JOIN Child ON ChildParent.ChildID = Child.ChildIDWHERe <ChildFilterCriteria>GROUP BY Parent.ParentIDHAVINg COUNT(*) = ( SELECt COUNT(Child.ChildID) FROM Child WHERe <ChildFilterCriteria>)



