请大虾看看语句的问题，谢谢～～

冰城星子

select * from (select 日期,区域,摘要,"客户返点" as 类别,[客户返点] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"业务招待费" as 类别,[业务招待费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"广告宣传费" as 类别,[广告宣传费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"市场支持费" as 类别,[市场支持费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"营销工资" as 类别,[营销工资] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"差旅费" as 类别,[差旅费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"差补金" as 类别,[差补金] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"提成" as 类别,[提成] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"其他1" as 类别,[其他1] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"经销商年会" as 类别,[经销商年会] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"营销经费" as 类别,[营销经费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"奖励" as 类别,[奖励] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"货运费" as 类别,[货运费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"汽车费" as 类别,[汽车费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"电话费" as 类别,[电话费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"低耗品" as 类别,[低耗品] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"其他2" as 类别,[其他2] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"员工福利" as 类别,[员工福利] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"汽油费" as 类别,[汽油费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"维修费" as 类别,[维修费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"产品研发费" as 类别,[产品研发费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"北京办事处房租" as 类别,[北京办事处房租] as 金额 from [sheet$a:Y])
where 日期 is not null

冰城星子

原表是一个多维表，我想用透视表来做些汇总分析，但是这个语句中出来的类别，怎么全部都是数据，而不是文字呢?  请大虾指点指点，谢谢～～～

安然祥和

错在from [sheet$a:Y]?
应是 from [sheet1$a:Y]
from [sheet2$a:Y]
.......

安然祥和

你能否弄个附件看看，总感觉你这个SQL代码有问题或可以精简。

冰城星子

安然祥和 发表于 2013-6-18 16:31
你能否弄个附件看看，总感觉你这个SQL代码有问题或可以精简。

我已经上传附件了，请帮我看看？

amazeyeli

双''''改单''

安然祥和

建议改为：
select 日期,区域,摘要,"客户返点" as 类别,[客户返点] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"业务招待费" as 类别,[业务招待费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"广告宣传费" as 类别,[广告宣传费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"市场支持费" as 类别,[市场支持费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"营销工资" as 类别,[营销工资] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"差旅费" as 类别,[差旅费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"差补金" as 类别,[差补金] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"提成" as 类别,[提成] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"其他1" as 类别,[其他1] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"经销商年会" as 类别,[经销商年会] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"营销经费" as 类别,[营销经费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"奖励" as 类别,[奖励] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"货运费" as 类别,[货运费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"汽车费" as 类别,[汽车费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"电话费" as 类别,[电话费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"低耗品" as 类别,[低耗品] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"其他2" as 类别,[其他2] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"员工福利" as 类别,[员工福利] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"汽油费" as 类别,[汽油费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"维修费" as 类别,[维修费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"产品研发费" as 类别,[产品研发费] as 金额 from [sheet$a:Y] union all
select 日期,区域,摘要,"北京办事处房租" as 类别,[北京办事处房租] as 金额 from [sheet$a:Y]

安然祥和

amazeyeli 发表于 2013-6-18 23:23
双''''改单''

还不行吧，不信你试试。