SQL Select Case

SELECT  d.USER_ID as '工号',d.USER_NAME AS '姓名', c.DIATHESISCONFIG_YEAR as 'Year',
 case a.DIATHESIS_NAME WHEN '应变能力' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '应变能力',
 case a.DIATHESIS_NAME WHEN '学习发展' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '学习发展',
 case a.DIATHESIS_NAME WHEN '活出玫琳凯' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '活出玫琳凯',
 
 case a.DIATHESIS_NAME WHEN '制定决策' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '制定决策',
 case a.DIATHESIS_NAME WHEN '激励激发' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '激励激发',
 case a.DIATHESIS_NAME WHEN '规划实现' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '规划实现',
 case a.DIATHESIS_NAME WHEN '策略思维' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '策略思维',
 
 case a.DIATHESIS_NAME WHEN '关注细节' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '关注细节',
 case a.DIATHESIS_NAME WHEN '树立信誉' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '树立信誉',
 case a.DIATHESIS_NAME WHEN '创造愿景' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '创造愿景',
 case a.DIATHESIS_NAME WHEN '沟通影响' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '沟通影响',
 case a.DIATHESIS_NAME WHEN '引领方向' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '引领方向',
 case a.DIATHESIS_NAME WHEN '团队合作' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '团队合作',
 case a.DIATHESIS_NAME WHEN '创新思维' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '创新思维',
 case a.DIATHESIS_NAME WHEN '自我激励' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '自我激励',
 case a.DIATHESIS_NAME WHEN '利用资讯' THEN  b.DIATHESIS_DETAILCONTENT  ELSE '' END AS '利用资讯'

 
 FROM MLK_PDP.dbo.test11 a,MLK_PDP.dbo.test22 b,MLK_PDP.dbo.test33 c,MLK_PDP.dbo.SEC_User d
 WHERE c.USER_ID=d.USER_ID 
 and (b.DIATHESIS_DETAILID=c.DIATHESIS_DETAILID  
 and a.DIATHESIS_SYSID=b.DIATHESIS_SYSID  or a.PARENT_ID=b.DIATHESIS_SYSID)  

 

转载于:https://www.cnblogs.com/gzh4455/archive/2012/09/25/2702173.html