17,082
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM ccicys.prpcmain WHERE 1=1 And OperateSite IS NOT NULL And SUBSTR(flag,6,1)='E'
AND ((1=1) AND ( RiskCode ='EYZ') OR( RiskCode ='EYX' AND OperateSite ='0000000415') )
SELECT *
FROM ccicys.prpcmain
WHERE 1=1 And
OperateSite IS NOT NULL
And SUBSTR(flag,6,1)='E'
AND ((1=1) AND INSTR(RiskCode,'EYZ') +(INSTR(RiskCode,'EYZ')*INSTR(OperateSite,'0000000415')) > 1 )