不同表链接count(表1)和sum(表2)函数结果集，急......

[dan74520]

如题

[dan74520]

select(select count(SubCode)from Speed
where convert(varchar(7),BeginDate,120) = '2012-09' )as spCount,
(select SUM(B.kiloDay)where convert(varchar(7),billdate,120) = '2012-09')as kiloSum,B.SubCode
from Kilo B
left join Speed A
on A.SubCode = B.SubCode
where convert(varchar(7),billdate,120) = '2012-09'
group by B.SubCode,A.SubCode,convert(varchar(7),billdate,120)

这个是我写的，但是出来的数据不对

[發糞塗牆]

你算聚合函数那里连from都没有的？不抱错吗？

[dan74520]

[Quote=引用 4 楼 的回复:]

你算聚合函数那里连from都没有的？不抱错吗？
[/Quote]

不报错

[發糞塗牆]

晕，这都能不报错？把你表结构给出来，最好给点数据吧。抽时间帮你谢谢select(select count(SubCode)from Speed
where convert(varchar(7),BeginDate,120) = '2012-09' )as spCount,
(select SUM(B.kiloDay)where convert(varchar(7),billdate,120) = '2012-09')as kiloSum,B.SubCode
from Kilo B
left join Speed A
on A.SubCode = B.SubCode
where convert(varchar(7),billdate,120) = '2012-09'
group by B.SubCode,A.SubCode,convert(varchar(7),billdate,120)

[开启时代]

select count(distinct a.字段),sum(b.字段)
from a inner join b on a.字段=b.字段

是不是楼主要的？

[老白猫]

select count(distinct a.字段) as acount
from a inner join b on a.字段=b.字段

select sum(b.字段) as bsum
from a inner join b on a.字段=b.字段
group by b.字段

啊