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=‘天津’ ) )