SELECT JNO
FROM J
EXCEPT
(SELECT DISTINCT SPJ.JNO
FROM S INNER JOIN
SPJ ON S.SNO = SPJ.SNO INNER JOIN
P ON SPJ.PNO = P.PNO
WHERE (S.CITY = '天津') AND (P.COLOR = '红'))
SQL Server2000中一直有错,请各位帮忙解答
FROM J
EXCEPT
(SELECT DISTINCT SPJ.JNO
FROM S INNER JOIN
SPJ ON S.SNO = SPJ.SNO INNER JOIN
P ON SPJ.PNO = P.PNO
WHERE (S.CITY = '天津') AND (P.COLOR = '红'))
SQL Server2000中一直有错,请各位帮忙解答
JNO
FROM
J
where
JNO not in(SELECT
DISTINCT SPJ.JNO
FROM S INNER JOIN SPJ ON S.SNO = SPJ.SNO
INNER JOIN P ON SPJ.PNO = P.PNO
WHERE (S.CITY = '天津') AND (P.COLOR = '红'))