SELECT
(CASE
WHEN c.CWSZLS_SZX = '1' THEN kh.KHXX_KHM
WHEN c.CWSZLS_SZX = '2' THEN gy.GYS_GYSMC
ELSE '' END
) AS szdxName,
c.*
FROM tb_cwszls c
left join tb_khxx kh on c.CWSZLS_SZDX = kh.KHXX_ID
left join tb_gys gy on c.CWSZLS_SZDX = gy.GYS_ID
sql选择条件查询case when else end
最新推荐文章于 2023-10-12 15:45:18 发布