數據透視表如何顯示6張表

Peter.777

那我請問一下.我自己研究要將四張表做數據透視表.結果語法出現問題.請幫我看看.另外是如果要很多張表該怎麼寫

select [期初明細$].廠別,[期初明細$].倉別,[期初明細$].品名,[期初明細$].物料編碼,[期初明細$].單位,[期初明細$].帳面 as 期初帳面,[期初明細$].庫存 as 期初庫存,[期初明細$].差異 as 期初差異,0 as 入庫帳面,0 as 入庫庫存,0 as 入庫差異,0 as 出庫帳面,0 as 出庫庫存,0 as 出庫差異,0 as 補料帳面,0 as 補料庫存,0 as 補料差異 from [期初明細$] union all select [入庫明細$].廠別,[入庫明細$].倉別,[入庫明細$].品名,[入庫明細$].物料編碼,[入庫明細$].單位,0 as 期初帳面,0 as 期初庫存,0 as 期初差異,0 as 出庫帳面,0 as 出庫庫存,0 as 出庫差異,[入庫明細$].帳面,[入庫明細$].庫存,[入庫明細$].差異,0 as 補料帳面,0 as 補料庫存,0 as 補料差異 from [入庫明細$] union all select [出庫明細$].廠別,[出庫明細$].倉別,[出庫明細$].品名,[出庫明細$].物料編碼,[出庫明細$].單位,0 as 期初帳面,0 as 期初庫存,0 期初差異,0 as 入庫帳面,0 as 入庫庫存,0 as 入庫差異,[出庫明細$].帳面,[出庫明細$].庫存,[出庫明細$].差異,0 as 補料帳面,0 as 補料庫存,0 as 補料差異 from [出庫明細$] union all select [補料明細$].廠別,[補料明細$].倉別,[補料明細$].品名,[補料明細$].物料編碼,[補料明細$].單位,0 as 期初帳面,0 as 期初庫存,0 as 期初差異,0 as 入庫帳面,0 as 入庫庫存,0 as 入庫差異,0 as 出庫帳面,0 as 出庫庫存,0 出庫差異,[補料明細$].帳面,[補料明細$].庫存,[補料明細$].差異 from [補料明細$]

wuxiang_123

1. SQL:
   
2. select 廠別,倉別,品名,物料編碼,單位,帳面 as 期初帳面,庫存 as 期初庫存,差異 as 期初差異,0 as 入庫帳面,0 as 入庫庫存,0 as 入庫差異,0 as 出庫帳面,0 as 出庫庫存,0 as 出庫差異,0 as 補料帳面,0 as 補料庫存,0 as 補料差異 from [期初明細$] union all
   
3. select 廠別,倉別,品名,物料編碼,單位,0,0,0,帳面,庫存,差異,0,0,0,0,0,0 from [入庫明細$] UNION ALL
   
4. select 廠別,倉別,品名,物料編碼,單位,0,0,0,0,0,0,帳面,庫存,差異,0,0,0 from [出庫明細$] UNION ALL
   
5. select 廠別,倉別,品名,物料編碼,單位,0,0,0,0,0,0,0,0,0,帳面,庫存,差異 from [補料明細$]

复制代码

Peter.777

12樓.謝謝你
再請教一個問題.當我看到別人做的數據透視表.想學他的SQL語句或者看他的SQL語句怎麼寫的.我從資料-->匯入外部資料-->編輯查詢 結果呈現白色無法點開來看.請問這是鎖住了嗎?如果鎖住該怎麼解開呢!

wuxiang_123

可以弄个图片或附件上来吗？这样不是很明白。灰色的原因有可能是根本不是用SQL编写的。

Peter.777

截取一張圖片.給各位參考

wuxiang_123

两个常用方法.你那里之所以变灰,是因为EXCEL以为你以数据透视表为数据源,用SQL创建.