求供应工程J1零件的供应商号码SNO.pptVIP

求供应工程J1零件的供应商号码SNO select sno from spj where jno = ‘j1’ select distinct sno from spj where jno = ‘j1’ 求供应工程J1零件P1的供应商号码SNO select sno from spj where jno = ‘j1’ and pno = ‘p1’ 求供应工程J1红色零件的供应商号码SNO ΠSNO ( σJNO = ‘j1’ ∧ color = ‘红’ (SPJ ∞ P) ) select sno from spj inner join p on spj.pno = p.pno where jno = ‘j1’ and color = ‘红’ select distinct sno from spj where jno = ‘j1’ and pno in (select * from p where color = ‘红’) 求没有使用天津供应商供应的红色零件的工程号JNO ΠJNO(J) － ΠJNO(σCOLOR=‘红色’ ∧ CITY=‘天津’ (SPJ ∞P∞S)) select jno from J where jno not in( select jno from s inner join spj on s.sno = spj.sno inner join p on p.pno = spj.pno where s.city = ‘天津’ and p.color = ‘红’ ) 求没有使用天津供应商供应的红色零件的工程号JNO SELECT JNO FROM J WHERE JNO NOT IN ( SELECT JNO FROM SPJ WHERE SNO IN ( SELECT SNO FROM S WHERE CITY=‘天津’ ) AND PNO IN ( SELECT PNO FROM P WHERECOLOR=‘红’ ) ) 查询至少用了供应商S1供应的全部零件的工称号。 ΠJNO, PNO (SPJ) ÷ΠPNO ( σSNO = ‘S1’ (SPJ) ) 查询至少用了供应商S1供应的全部零件的工称号。 对于给定一个工程号，假设J1，怎样J1保证使用S1供应的全部零件。 查询一个零件， S1供应了该零件，但J1没有使用。如果这样的零件查不到，则J1使用S1供应的全部零件。 查询一个零件， S1供应了该零件，但J1没有使用。如果这样的零件查不到，则J1使用S1供应的全部零件。 select jno from j where not exists( seect * from p where exists ( select * from spj where spj.pno = p.pno and spj.sno = ‘s1’ ) and not exists ( select * from spj where spj.pno = p.pno and spj.jno = ‘j1’ ) ) 找出所有供应商的姓名和所在城市。 select sname, city from s 找出所有零件的名称、颜色和重量。 select pname, color, weight from P 找出使用供应商S1所供应零件的工程号 select jno from spj where sno = ‘s1’ select distinct jno from spj where sno = ‘s1’ 找出工程项目J2使用的各种零件的名称及数量 select pname, qty from spj inner join p on spj.pno = p.pno where jno = ‘j2’ select pname, sum(qty) from spj inner join p on spj.pno = p.pno where jno = ‘j2’ group by pname 找出上海厂商供应的所有零件号码 select pno from spj inner join s on spj.sno = s.sno where city = ‘上海’ select distinct pno from sp