sql case when

最新推荐文章于 2024-09-24 22:55:18 发布

yihuei123

最新推荐文章于 2024-09-24 22:55:18 发布

阅读量1.3k

点赞数

文章标签： sql mobile 物流

本文链接：https://blog.csdn.net/yihuei123/article/details/1884227

版权

select t1.mainregion 运作地,
       t1.customercode 客户编号,
       t1.customernamecn 名称,
       --t1.businesstype,
       case when t1.businesstype = 'IMP' then '进口'
            when t1.businesstype = 'EXP' then '出口'
            when t1.businesstype = 'SAL' then '销售'
            when t1.businesstype = 'TRS' then '物流'
            end businesstype,
       t1.createdate 创建时间,
       e.name 商务经理,
       'tel:' || e.telephone || ' mobile:' || e.mobilephone tel,
       case when t1.islock = 'N' then '否'
            when t1.islock = 'Y' then '是'
            end islock
from eapt_customer t1, employee e
where (t1.warehouseftcout = 56
    or t1.warehouseftcin = 56) and e.username = t1.principal2