求没有使用天津供应商生产的红色零件的工程号jno
use spj;
select JNO
from spj join p using(PNO)
join s using(SNO)
where not exists(select* from s where CITY='天津') and
not exists(select* from p where COLOR='红')
求没有使用天津供应商生产的红色零件的工程号jno
use spj;
select JNO
from spj join p using(PNO)
join s using(SNO)
where not exists(select* from s where CITY='天津') and
not exists(select* from p where COLOR='红')