j2.sql

来自「数据库方面的知识 最基本的建表」· SQL 代码 · 共 9 行

SELECT DISTINCT SNO
FROM SPJ
WHERE JNO='J1';
SELECT DISTINCT SNO
FROM SPJ
WHERE JNO='J1'AND PNO='P1';
SELECT DISTINCT SNO
FROM P,SPJ
WHERE  P.COLOR='红'AND SPJ.PNO=P.PNO AND SPJ.JNO='J1';