多表汇总语句错在哪里？

janne.71

老师好，学友好，汇总2个年度销售额并计算奖金

1. 
   
2. select a.*,iif(a.销售额>500,a.销售额*6.2%,iif(a.销售额>300,a.销售额*4.2%,iif(a.销售额>50,a.销售额*1.2%,0))) as 奖金 from
   
3. (select "2010" as 年度,客户,sum(数量) as 销售量,sum(销售金额) as 销售额,sum(销售金额)/sum(数量) as 单价
   
4. from [2010$] group by   客户,"2010" union all
   
5. select "2011" as 年度,客户,sum(数量) as 销售量,sum(销售金额) as 销售额,sum(销售金额)/sum(数量) as 单价
   
6. from [2011$] group by 客户,"2011")a

复制代码

suwenkai

你把6.2%这种有百分比的改成0.062应该就可以了。

1. select *,iif(a.销售额>500,a.销售额*.062,iif(a.销售额>300,a.销售额*0.042,iif(a.销售额>50,a.销售额*0.012,0))) as 奖金 from
   
2. 
   
3. (select "2010" as 年度,客户,sum(数量) as 销售量,sum(销售金额) as 销售额,sum(销售金额)/sum(数量) as 单价
   
4. from [2010$] group by 客户 union all
   
5. select "2011" as 年度,客户,sum(数量) as 销售量,sum(销售金额) as 销售额,sum(销售金额)/sum(数量) as 单价
   
6. from [2011$] group by 客户 ) a
   

复制代码

[ 本帖最后由 suwenkai 于 2010-11-25 14:01 编辑 ]

janne.71

谢谢老师，这是为什么呢？
因为 LIKE %*%  通用操作符？

[ 本帖最后由 janne.71 于 2010-11-25 14:33 编辑 ]

suwenkai

请检查一下你的语句是不是有中文符号。

平帆

已经用了SQL，再用列表，就多余了吧