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)