SELECT (
CASE WHEN left(p.obj_type,2)='11' THEN 'LD' ELSE mj.USR END) as 审核人,mj.IJ_NO 单号
from MF_IJ mj
left join tf_ij tj on tj.ij_no=mj.ij_no
left join prdt p on p.prd_no=tj.prd_no
where mj.IJ_NO like 'WI%' and mj.IJ_NO=@billNO
如何改成当金额小于等于2000提交给用户2000 大于提交给用户2审核?
------解决思路----------------------
请加标点,没搞明白!
是这个意思吗?
(CASE WHEN 有金额的表.金额 <= 2000 THEN '通过'
WHEN left(p.obj_type,2)='11' THEN 'LD'
ELSE mj.USR
END) as 审核人,
------解决思路----------------------
SELECT (CASE WHEN left(p.obj_type,2)='11' THEN 'LD' ELSE mj.USR END) as 审核人,mj.IJ_NO 单号
,(CASE WHEN 金额<=2000 THEN 用户1 ELSE 用户2 END) as 审核人
--我不清楚表结构,不知道哪上是金额字段
from MF_IJ mj
left join tf_ij tj on tj.ij_no=mj.ij_no
left join prdt p on p.prd_no=tj.prd_no
where mj.IJ_NO like 'WI%' and mj.IJ_NO=@billNO