56,677
社区成员
发帖
与我相关
我的任务
分享
where
(APPROVAL_CLASS = '11' AND APPROVAL_FLG = '1') AND (APPROVAL_CLASS<>'07' AND APPROVAL_CLASS<>'11')
OR
(APPROVAL_CLASS <> '11' OR APPROVAL_FLG <> '1') AND (APPROVAL_CLASS='07' OR APPROVAL_CLASS='11')
IF(
(APPROVAL_CLASS = '11' AND APPROVAL_FLG = '1'),
(APPROVAL_CLASS<>'07' AND APPROVAL_CLASS<>'11'),
(APPROVAL_CLASS='07' OR APPROVAL_CLASS='11')
)
IF(
(APPROVAL_CLASS = '11' AND APPROVAL_FLG = '1'),
INSTR('07,11,', CONCAT(APPROVAL_CLASS,','))=0,
INSTR('07,11,', CONCAT(APPROVAL_CLASS,','))>0
)