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=‘红’