17,086
社区成员
发帖
与我相关
我的任务
分享
select *
from tableA
where ((ozi.TOTALFEE > 0) OR (ozi.NETCODE = '02' AND ozi.PAY_MODE = '03'))
AND ozi.ACCT_MONTH = '200810'
AND ozi.pay_mode IN ('03', '04');
select *
from tableA
where ((ozi.TOTALFEE > 0) OR (ozi.NETCODE = '02' AND ozi.PAY_MODE = '03'))
AND ozi.ACCT_MONTH = '200810';
--很显然,第一句多了个AND ozi.pay_mode IN ('03', '04')条件啊?!