sql CASE WHEN 使用

select 
                sp.researchId,
                d.name doctorName,

                p.name patientName,


                h.name hospitalName,
                    ad3.`name` provinceName,
                    ad2.`name` cityName,
                a.`name` districtName,

CASE WHEN h.address is NULL
                    THEN d.address

                    ELSE h.address END address,

                CASE WHEN ra.audits = 0
                    THEN '待审核'
                    WHEN ra.audits = 1 THEN '审核中'
WHEN ra.audits = 3 THEN '脱落'
WHEN ra.audits = 4 THEN '中止'
WHEN ra.audits = 5 THEN '初审(不通过)'
WHEN ra.audits = 6 THEN '初审(通过)'
WHEN ra.audits = 7 THEN '审核通过'
WHEN ra.audits = 8 THEN '审核不通过'
                    ELSE '未知' END audits
                from survey_patient sp
                INNER JOIN research_audits ra on ra.research_id=sp.researchId
                INNER JOIN doctor d on d.happyness_id=sp.happyness_id_doctor
                INNER JOIN hospital h on h.id=d.hospital_id
                INNER JOIN address a on a.id=h.district_id
                INNER JOIN patient p on p.happyness_id=sp.happyness_id_patient
                LEFT JOIN address ad2 on ad2.id=a.parent_id
                LEFT JOIN address ad3 on ad3.id=ad2.parent_id

                GROUP BY sp.researchId
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值