【Vegas原创】SQL case when 用法
select form_no,cource,hbddept,empno,hbdcnm,substring(empno,1,4) as eDate,
case ctype when '1' then '内训' when '0' then '外训' end
from old,etsshbd
where old.empno=etsshbd.hbdwno
case ctype when '1' then '内训' when '0' then '外训' end
from old,etsshbd
where old.empno=etsshbd.hbdwno
喜欢请赞赏一下啦^_^
![](https://images.cnblogs.com/cnblogs_com/amadeuslee/1997630/o_21070809243911.jpg)