aaa表
pk date(月) divsion
1 01 1
2 02 2
3 03 1
4 04 1
5 05 1
-------------------------------------------bbb表
pk date numbers divsion
1 20050105 1 1
2 20050605 1 1
3 20050105 1 1
4 20050305 2 2
5 20050105 3 2
-----------------------------------------------select
a.divsion,b.sum(numbers),c.sum(numbers),
form
aaa a left outer join bbb b on
(a.divsion = b.divsion
and b.data>=20050101 and b.date<20050201)left outer join bbb c on
(a.divsion = c.divsion
and c.data>=20050201 and c.date<20050301)group by
.......
pk date(月) divsion
1 01 1
2 02 2
3 03 1
4 04 1
5 05 1
-------------------------------------------bbb表
pk date numbers divsion
1 20050105 1 1
2 20050605 1 1
3 20050105 1 1
4 20050305 2 2
5 20050105 3 2
-----------------------------------------------select
a.divsion,b.sum(numbers),c.sum(numbers),
form
aaa a left outer join bbb b on
(a.divsion = b.divsion
and b.data>=20050101 and b.date<20050201)left outer join bbb c on
(a.divsion = c.divsion
and c.data>=20050201 and c.date<20050301)group by
.......
a.divsion,b.date,b.sum(numbers)
from
aaa a left outer join bbb b on
a.divsion = b.divsion
group by a.divsion,b.date
表中还要取些字段,没有列出来 回复人:wgsasd311(自强不息) ( 两星(中级)) 信誉:100 2006-02-27 20:00:00 得分:0
?
select
a.divsion,b.date,b.sum(numbers)
from
aaa a left outer join bbb b on
a.divsion = b.divsion
group by a.divsion,b.date-----------------------------这个也不行啊,是要根据日期对各个月份的numbers有个统计