上传者: ghostvater_kun
|
上传时间: 2022-04-03 23:16:12
|
文件大小: 19KB
|
文件类型: -
(1)求供应工程J1零件的供应商号码SNO:
select sno from spj where jno = 'J1';
(2)求供应工程J1零件P1的供应商号码SNO:
select sno from spj where jno ='J1' and pno = 'P1';
(3)求供应工程J1零件为红色的供应商号码SNO:
select sno from spj natural join p where jno = 'J1'and color = '红';
(4)求没有使用天津供应商生产的红色零件的工程号JNO:
select jno from spj where jno not in(select jno from spj natural join s natural