三个表汇总成数据透视表

豆豆0898

现在有三个格式有一些不太一样的表格..想根据里面的表格汇总成数据透视表.....大神们帮我看一下用SELECT语句要怎么做???
select "库存",款式编号,仓库名称,库存数量 as from[库存$] union all select "调配",款式编号,收货地名称,调配数量 as from[调配$] union all select "销售",款式编号,店柜名称,销售数量 as from[销售$]
我用这个语句但是提示是错误的....

豆豆0898

俺又换了一个写了......格式是出来了...不过里面的数据导入的却不对了....
select 款式编号,店铺名称,总库存数量,0 as 调配数量,0 as 销售数量 from [库存$] union all select 款式编号,店铺名称,调配数量,0 as 总库存数量,0 as 销售数量 from [调配$] union all select 款式编号,店铺名称,销售数量,0 as 总库存数量,0 as 调配数量 from [销售$]

哪位大神帮我改一下...