请教用SQL语句如何做出附件中这样格式的数据视表

sixunica

想做出好附件中这样格式的数据透视表有办法吗？ 请大家帮帮忙啊，谢谢！

wuxiang_123

1. 
   
2. SELECT "销售" AS 进出,品名,月份&"月" AS 月份,"总销售量" AS 分类,总销售量 AS 值 FROM
   
3. (SELECT * FROM [A销售$]
   
4. UNION ALL
   
5. SELECT * FROM [B销售$]
   
6. UNION ALL
   
7. SELECT * FROM [C销售$]
   
8. )
   
9. UNION ALL
   
10. SELECT "销售",品名,月份&"月","销售额",销售额 FROM
    
11. (SELECT * FROM [A销售$]
    
12. UNION ALL
    
13. SELECT * FROM [B销售$]
    
14. UNION ALL
    
15. SELECT * FROM [C销售$]
    
16. )
    
17. UNION ALL
    
18. SELECT "库存",品名,"","库存数量",库存数量 FROM [库存$]
    
19. UNION ALL
    
20. SELECT "库存",品名,"","库存金额",库存金额 FROM [库存$]

复制代码

sixunica

谢谢，就是要这个效果，但是还有个问题，在汇总时数量和金额会被算到一起······，不知有没有办法让它们分开来汇总啊···

wuxiang_123

可以做,依样画葫芦就可以了.

sixunica

自已画了一下午也没画出来··呵呵

sixunica

做不出数量和金额分开汇总的效果，麻烦帮忙做下吧，谢谢

亡者天下

麻烦wuxiang解释一下你的SQL语句，
我捣鼓了半天都没有弄出来

wuxiang_123

1. SELECT "销售" AS 进出,品名,月份&"月" AS 月份,总销售量,销售额 FROM
   
2. (SELECT * FROM [A销售$]
   
3. UNION ALL
   
4. SELECT * FROM [B销售$]
   
5. UNION ALL
   
6. SELECT * FROM [C销售$]
   
7. )
   
8. UNION ALL
   
9. SELECT "库存",品名,"",库存数量,库存金额 FROM [库存$]
   

复制代码

sixunica

非常感谢，学习了