帮帮忙啊

[hellward]

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中一直有错,请各位帮忙解答

[子陌红尘]

SELECT 
    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 = '红')) 

[-狙击手-]

Analysis Services中使用的？

[-狙击手-]

t-sql无法使用

[hellward]

为什么要这样改啊?

[kyd169]

有心无力哦　只会MySql哦　

[viva369]

什么错？

[hellward]

为什么啊

[-狙击手-]

[Quote=引用 7 楼 hellward 的回复:]
为什么啊
[/Quote]
t-sql中无法使用这个函数