销售与应收表的透视表出错怎么改正?

zsp1314 · 发表于 2010-11-23 12:07

销售与应收表的透视表出错怎么改正?
我写的: select 单位名称,联系人,收款金额,0 as 金额,0 as 期初应收账款余额,"收款" as 类别 from [收款明细表$A2:R1000] union select 单位名称,联系人,0 as 收款金额,金额,0 as 期初应收账款余额,"出售" as 类别 from [销售明细表$A2:r1000] union select 单位名称,联系人,0 as 收款金额,0 as 金额,期初应收账款余额,"余款" as 类别 from [应收帐款余额表$A5:R130]
这样写后出现"参数不足,期待是1"

suwenkai · 发表于 2010-11-23 12:19

select 单位名称,联系人,收款金额,0 as 金额,0 as 期初应收账款余额,"收款" as 类别 from [收款明细表$A2:R1000]
union all
select 单位名称,联系人,0 as 收款金额,金额,0 as 期初应收账款余额,"出售" as 类别 from [销售明细表$A2:r1000]
union all
select 单位名称,联系人,0 as 收款金额,0 as 金额,期初应收帐款余额,"余款" as 类别 from [应收帐款余额表$A5:R130]

复制代码

mn860429 · 发表于 2010-11-23 12:47

http://club.excelhome.net/viewth ... p;extra=&page=2

zsp1314 · 发表于 2010-11-23 12:45

谢谢!!为什么你加了一个"ALL"就可以,我原来也有这个的,但看了"关于多个工作表的数据透视表的问题？"这个贴BIN_YANG168写的查询语句：

select 月份,负责人,品种,数量,金额,'1月' as 定义 from [1月$] union select 月份,负责人,品种,数量,金额,'2月' as 定义 from [2月$] union select 月份,负责人,品种,数量,金额,'3月' as 定义 from [3月$] union select 月份,负责人,品种,数量,金额,'4月' as 定义 from [4月$]
没有ALL也可以,所以我也删除了!请问我的问题在哪里呢!,麻烦再指正一下!谢谢!

zsp1314 · 发表于 2010-11-23 13:20

谢谢!!小弟看到了解释
union是去掉重复，
union all是连接所有的记录。
只可惜到现在还是照猫画虎!!出问题就不知所措!
如果我都改回union all 作连接 ,望指正附件中我写的和老师写的有什么不同!

[ 本帖最后由 zsp1314 于 2010-11-23 13:27 编辑 ]

		自动登录	找回密码
密码			免费注册

[求助] 销售与应收表的透视表出错怎么改正?