关泉数据库 习题
求供应工程J零件的供应商号SNO (S、P、J、SPJ) SQL) SELECT SNO FROM SPJ WHERE J=‘J1
1 求供应工程J1 零件的供应商号SNO . （ S、P、J、SPJ ） ■ SQL SELECT SNO FROM SPJ WHERE J=‘J1’
2求供应工程J零件P1的供应商号SNO;(S、P、JSPJ) SQL SELECT SNO FROM SPJ WHERE J=6J1’ANDP=“P1
2 求供应工程J1 零件 P1 的供应商号SNO ; （ S、P、J、SPJ ） ■ SQL SELECT SNO FROM SPJ WHERE J=‘J1’ AND P=‘P1’
3求供应工程J红色零件的供应商号SNO;(S、P、J、SPJ) SQL SELECT SNO FROM SPJ. P WHERE J=J1 AND PPNO=SPJ PNO AND COLOR=红 SELECT SNO FROM SPJ WHERE J=5J1’ AND PNO N SELECT PNO FROM WHERE COLOR=“红
3 求供应工程J1 红色零件的供应商号SNO ; （ S、P、J、SPJ ） ■ SQL SELECT SNO FROM SPJ , P WHERE J=‘J1’ AND P.PNO=SPJ.PNO AND COLOR=‘红’ SELECT SNO FROM SPJ WHERE J=‘J1’ AND PNO IN (SELECT PNO FROM p WHERE COLOR=‘红’
4求没有使用天津供应商生产的红色零件的工程号JNO SQL SELECT NO FROM WHERE JNO NOT IN SELECT JNO FROM SPJ WHERE PNO N C SELECT PNO FROM WHERE COLOR=“红 AND SNO IN C SELECT SNO FROM S WHERE CITY=天津
4 求没有使用天津供应商生产的红色零件的工程号JNO . ■ SQL SELECT JNO FROM J WHERE JNO NOT IN (SELECT JNO FROM SPJ WHERE PNO IN ( SELECT PNO FROM P WHERE COLOR=‘红’ ) AND SNO IN ( SELECT SNO FROM S WHERE CITY=‘天津’ ) )