数据库中或的操作错误

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