select * from tbky_syscfg where JZNUM>=1 and JZNUM<=3 and (QDNUM=1 or QDNUM=2) and Not Exists(select 1 from tbky_freqrec where JZNUM=tbky_syscfg.JZNUM and QDNUM=tbky_syscfg.QDNUM
少个括号? 错误是什么?select * from tbky_syscfg where JZNUM>=1 and JZNUM <=3 and (QDNUM=1 or QDNUM=2) and Not Exists(select 1 from tbky_freqrec where JZNUM=tbky_syscfg.JZNUM and QDNUM=tbky_syscfg.QDNUM)
select * from tbky_syscfg where JZNUM>=1 and JZNUM <=3 and (QDNUM=1 or QDNUM=2) and Not Exists(select 1 from tbky_freqrec where JZNUM=tbky_syscfg.JZNUM and QDNUM=tbky_syscfg.QDNUM) 语法没错误!
错误是什么?select * from tbky_syscfg where JZNUM>=1 and JZNUM <=3 and (QDNUM=1 or QDNUM=2) and Not Exists(select 1 from tbky_freqrec where JZNUM=tbky_syscfg.JZNUM and QDNUM=tbky_syscfg.QDNUM)