请教sql

shgzf

表A，表B，通过pk关联
表A
YEAR MONTH PK
2006 1 AAAAAAAAAAAAAAAA
2006 1 AAAAAAAAAAAAAAAA
2006 1 AAAAAAAAAAAAAAAA
2006 2 BBBBBBBBBBBBBBBB
2006 2 BBBBBBBBBBBBBBBB
2006 3 CCCCCCCCCCCCCCCC

表B
PK MONEY
AAAAAAAAAAAAAAAA 100000.0000
AAAAAAAAAAAAAAAA 200000.0000
BBBBBBBBBBBBBBBB 333333.0000
CCCCCCCCCCCCCCCC 444444.0000

select a.year,a.month,sum(b.money)
from a,b
where a.pk=b.pk
group by a.year,a.month

结果显示：
YEAR MONTH SUM(B.MONEY)
2006 1 900000
2006 2 666666
2006 3 444444
而我实际需求是：
YEAR MONTH SUM(B.MONEY)
2006 1 300000
2006 2 333333
2006 3 444444
不知道怎么写，请大家帮帮忙

jametong

明显是表A的数据重复导致的..

将重复的数据处理掉就好了啊..

select a.year,a.month,sum(b.money)
from (
  select distinct year,month,pk from a
) a,b
where a.pk=b.pk
group by a.year,a.month

xieyizhi

没有严格定义表的结构！应设置唯一