(case
when (select c.pay
from test c
where c.claimno = a.claimno) in ('0', '1', '3') then
'3'
else
(case
when (select c.auditing
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1', '3') then
'3'
else
(case
when (select c.checkPay from c_processstatus c where c.claimno=a.claimno) in ('0', '1', '3') then
'3'
else
(case
when (select c.auditing from c_processstatus c where c.claimno=a.claimno) in ('0', '1', '3') then
'3'
else
(case
when (select c.lhauditing
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1') then
'3'
else
(case
when a.endstatus = '4' then
'7'
else
(case
when a.endstatus = '2' then
'9'
else
(case
when (select c.notify
from c_processstatus c
where c.claimno = a.claimno) <> '2' then
'2'
else
(case
when (select c.dispatchSurvey
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1', '3') then
'2'
else
(case
when (select c.estimate
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1', '3') then
'2'
else
(case
when (select c.surveyreport
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1', '3') then
'2'
else
(case
when (select c.auditPrice
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1', '3') then
'2'
else
(case
when (select c.lhauditprice
from c_processstatus c
where c.claimno = a.claimno) in ('0', '1') then
'2'
else
(case
when (select c.voucher
from c_processstatus c
where c.claimno = a.claimno) = '1' then
'2'
else
'0'
end) end) end) end) end) end) end) end) end) end) end) end) end) end) as claimStatus,
很多的case when then else end
最新推荐文章于 2023-01-05 18:01:30 发布