SQL Server CASE WHEN ... THEN ... ELSE ... END

复制代码
SELECT a.*,b.dp_name,c.pa_name,fm_name=(CASE WHEN a.fm_no='LJCG001H' THEN  dbo.ELTPNAME(a.fw_nu) ELSE  d.fm_name END),e.fw_state_nm,f.fw_rmk_nm 

FROM LJSS007H a (nolock)

left join LJPA003H b (nolock) on a.dp_no=b.dp_no

left join LJPA001H c (nolock) on c.pa_no=a.pa_no1

left join LJSS002H d (nolock) on d.fm_no=a.fm_no

left join LJSS008H e (nolock) on a.fw_state=e.fw_state_no

left join LJSS009H f (nolock) on a.fw_rmk_no=f.fw_rmk_no

WHERE a.fw_state>=2 And a.pa_no ='A0202002' and a.cr_time>='2024-07-01 00:00:00' and a.cr_time<='2024-07-19 23:59:59'

复制代码
posted @   侬侬发  阅读(13)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 25岁的心里话
· 闲置电脑爆改个人服务器(超详细) #公网映射 #Vmware虚拟网络编辑器
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 零经验选手,Compose 一天开发一款小游戏!
· 一起来玩mcp_server_sqlite,让AI帮你做增删改查!!
点击右上角即可分享
微信分享提示