透视表sql语句纠错

100米跳远

各位大侠麻烦看看这个语句有什么错误
Select Month, location, Actual Delivered Volume, Deferment,Process Area /Equipment Tag, Global Immediate Cause, Activity Owner, Root Cause Narrative as "item" from [Unavailable Capacity Deferment$] union all Select Month, location, Actual Delivered Volume, Deferment,Process Area /Equipment Tag, Global Immediate Cause, Activity Owner, Category as "item" from [Unavailable Capacity Deferment$] union all Select Month, location, Actual Delivered Volume, Deferment,Process Area /Equipment Tag, Global Immediate Cause, Activity Owner, LOW/OFF as "item" from [Unavailable Capacity Deferment$]

masterexcel

建议：
检查字段名种是否有不可见字符，把所有的字段名用[]括起来

100米跳远

英文列标题因语言表述的需要中有空格。感谢！

suwenkai

这么快就被解决了。

100米跳远

加了[ ]符号，还是没有搞定。劳驾大侠在给瞧瞧！

100米跳远

没有呢！？呵呵

wxin0708

看得头都晕了

mn860429

楼主还是传个附件吧，确实太长了

100米跳远

搞定了。总结如下：1. select 语句后[ ]的用法，需要添加。2. as 语句，添加必须是新的字段。3. 数据源需为数据清单。