22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT a.ID, (CASE e.Name WHEN 'AA' THEN CAST(b.czwt AS varchar) ELSE 'X' END) AS 'AA',
(CASE e.Name WHEN 'BB' THEN CAST(b.czwt AS varchar) ELSE 'X' END) AS 'BB',
(CASE e.Name WHEN 'CC' THEN CAST(b.czwt AS varchar) ELSE 'X' END) AS 'CC'
FROM a INNER JOIN
b ON a.ID = b.XX_ID INNER JOIN
c ON b.hfz = c.ID INNER JOIN
e ON c.CJ = e.ID
GROUP BY a.ID
order by e.Name,b.czwt