求至少用了供应商s1所供应的全部零件的工程号jno

这个问题今天百度了一下答案,然后运行之后发现结果不正确,仔细检查才发现百度上的答案少了一句spjx.sno=‘s1’,加上之后运行可以得出正确答案,下面贴出正确答案:

SELECT DISTINCT jno
FROM spj spjz
WHERE NOT EXISTS
(SELECT * FROM spj spjx
WHERE spjx.sno=‘s1’ AND NOT EXISTS
(SELECT * FROM spj spjy
WHERE spjy.pno=spjx.pno
AND spjy.jno=spjz.jno
));