数据库中或的操作错误

ane9542

于 2018-05-17 22:19:00 发布

阅读量126

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/satisfysmy/p/9053652.html

版权

SQL 中的或用的是 in 而不是 or

错误的或

SELECT COUNT(1) FROM Trade_Tradeinfo_Oda a ,Trade_Tradeinfo_Oda_Return b
     WHERE 1=1 AND substr(a.area2,4)=substr(b.area2,3) AND substr(a.area11,3)=b.area11 AND substr(a.area42,4)=b.area42
     AND substr(a.area60,length(a.area60)-6)=substr(b.area60,length(b.area60)-6)
     AND a.FILEFLAG='02'    AND a.FILEFLAG='03'   AND a.FILENAME IS NULL

正确的或

SELECT COUNT(1) FROM Trade_Tradeinfo_Oda a ,Trade_Tradeinfo_Oda_Return b WHERE 1=1 AND substr(a.area2,4)=substr(b.area2,3) AND substr(a.area11,3)=b.area11 AND substr(a.area42,4)=b.area42 AND substr(a.area60,length(a.area60)-6)=substr(b.area60,length(b.area60)-6)

AND a.FILEFLAG N('02','03') AND a.FILENAME IS NULL

转载于:https://www.cnblogs.com/satisfysmy/p/9053652.html