SQL 查询出错 求解

hxb5732410

select *,a.数目/b.数目 as 占比 from (select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部,经销商) as a,(select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部) as b where a.经理部=b.经理部  这个SQL 语句有什么错误啊？
    导入  反馈    试图执行的查询中不包含作为合计函数一部分的特定表达式"经销商"。

[ 本帖最后由 hxb5732410 于 2010-10-28 15:11 编辑 ]

styhs

select *,a.数目/b.数目 as 占比 from (select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部,经销商) as a,(select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部) as b where a.经理部=b.经理部

红色部分出错，应为：
select *,a.数目/b.数目 as 占比 from (select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部,经销商) as a,(select 经理部,经销商,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部,经销商) as b where a.经理部=b.经理部

hxb5732410

那改了以后  就
a=b  了啊

魂断蓝桥

是不是分类汇总百分比的问题。

试一试
select *,a.数目/b.数目 as 占比 from (select 经理部,经销商,count(底盘号) as 数目 from [sheet1$] group by 经理部,经销商) as a,(select 经理部,count(底盘号) as 数目 from [sheet1$] group by 经理部) as b where a.经理部=b.经理部

hxb5732410

你太神了   为什么要去掉b 中的经销商呢？

魂断蓝桥

你运行一下

select 经理部,count(底盘号) as 数目 from [sheet1$] group by 经理部

就明白了。

suwenkai

不要经销商也可以。分组里有就可以了。
select *,a.数目/b.数目 as 占比
from
(select 经理部,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部,经销商) as a,
(select 经理部,count(底盘号) as 数目 from [周转库存明细表$] group by 经理部) as b
where a.经理部=b.经理部

蓝颜知己是他