17,090
社区成员
发帖
与我相关
我的任务
分享
select jl,sj,yg,
case when (jl=1 or (jl=2 and sj != 0)) and a.yg=0 then '需员工确认'
when jl=2 and sj = 0 then '需领导确认'
when jl = 2 and sj != 0 then '已领导确认'
when yg = 1 then '已员工确认' end sta
from A