select Groups,[2017] as 'Balance-2017',[2018] as 'Balance-2018' from( select G...
在DW環境底下, 我會這麼寫.Select Groups,SUM(case when Years='2017' then Balance else 0 end)...
你沒畫表格看起來好亂 Years Groups Balance 2017 1-Net Sales 4035508.167 2017 2-COG...
ACCESS只能吃這樣的SQL，要多敲一些鍵盤。 SELECT A.Groups , B.Balance AS [Balance-2017]...
rogermou的鐵人檔案