SELECT DISTINCT JNO FROM SPJ
WHERE JNO IN (SELECT DISTINCT X.JNO
FROM SPJ AS X, SPJ AS Y
WHERE X.JNO=Y.JNO
AND X.PNO=‘P3’
AND Y.PNO=‘P5’)
GROUP BY SPJ.JNO
HAVING COUNT(DISTINCT (PNO))=2
检索只使用了P3和P5的工程编号JNO(含S,P,J,SPJ表)
最新推荐文章于 2023-06-11 07:45:00 发布