TRANSFORM Sum(Region.[MJ]) AS MJHZ
SELECT Region.[XZQDM], Region.[XZQMC], Region.[SJDM]
FROM Region
GROUP BY Region.[XZQDM], Region.[XZQMC], Region.[SJDM]
PIVOT Region.[ZBDM]
关键字:TRANSFORM、GROUP BY、PIVOT
TRANSFORM Sum(Region.[MJ]) AS MJHZ
SELECT Region.[XZQDM], Region.[XZQMC], Region.[SJDM]
FROM Region
GROUP BY Region.[XZQDM], Region.[XZQMC], Region.[SJDM]
PIVOT Region.[ZBDM]
关键字:TRANSFORM、GROUP BY、PIVOT