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)