>SELECT * > FROM master m > WHERE EXISTS ( SELECT 1 FROM slave s > WHERE s.fk = m.pk HAVING COUNT(*) = SUM( CASE WHEN <condition> THEN 1 ELSE 0 END )) >