SELECT JNO
FROM J
WHERE NOT EXISTS
(SELECT 'X'
FROM SPJ WHERE SPJ.JNO = J.JNO AND SNO IN (SELECT SNO
FROM S
WHERE CITY = '天津'));消息 102,级别 15,状态 1,第 1 行
' ' 附近有语法错误。
消息 102,级别 15,状态 1,第 1 行
')' 附近有语法错误。恕小弟初学,实在是找不到错误啊。
FROM J
WHERE NOT EXISTS
(SELECT 'X'
FROM SPJ WHERE SPJ.JNO = J.JNO AND SNO IN (SELECT SNO
FROM S
WHERE CITY = '天津'));消息 102,级别 15,状态 1,第 1 行
' ' 附近有语法错误。
消息 102,级别 15,状态 1,第 1 行
')' 附近有语法错误。恕小弟初学,实在是找不到错误啊。
FROM J
WHERE NOT EXISTS ( SELECT 'X'
FROM SPJ
WHERE SPJ.JNO = J.JNO
AND SNO IN ( SELECT SNO
FROM S
WHERE CITY = '天津' ) ) ;看起来没啥错误啊!
SELECT JNO
FROM J
WHERE NOT EXISTS
(SELECT 'X'
FROM SPJ WHERE SPJ.JNO = J.JNO AND SNO IN (SELECT SNO
FROM S
WHERE CITY = '天津'));
FROM J
WHERE NOT EXISTS (SELECT 1
FROM SPJ
WHERE SPJ.JNO = J.JNO AND SNO IN (SELECT SNO FROM S WHERE CITY = '天津'))