关于mysql的问题提问！

select jno from spj;
可以有结果
select jno from spj,p,s where s.city='天津' and color='红’ and s.sno=spj.sno and p.pno=spj.pno
也有结果
SELECT JNO FROM SPJ WHERE JNO NOT IN (SELECT JNO FROM SPJ,P,S WHERE S.CITY='天津' AND COLOR='红' AND S.SNO=SPJ.SNO AND P.PNO=SPJ.PNO)
和起来 怎么就提示有语法错误呢
是不是not in 那里的 错误啊
知道的 麻烦告诉下我啊！！

SELECT JNO FROM SPJ,P,S WHERE S.CITY='天津' AND COLOR='红' AND S.SNO=SPJ.SNO AND P.PNO=SPJ.PNO 语句能正确执行不？