您可以使用 NOT EXISTS
SELECT id
FROM Parent p
WHERE NOT EXISTS
(
SELECT 1 FROM Child c
WHERE c.parent_Id = p.id
AND c.x <> c.y
)
编辑:这是sql小提琴:http ://sqlfiddle.com/#!3/20128/1/0
如果所有孩子均符合条件,则选择父母
您可以使用 NOT EXISTS
SELECT id
FROM Parent p
WHERE NOT EXISTS
(
SELECT 1 FROM Child c
WHERE c.parent_Id = p.id
AND c.x <> c.y
)
编辑:这是sql小提琴:http ://sqlfiddle.com/#!3/20128/1/0