表A
a1 a2 a3
--------------------
aaa bbbb 10
aaa cccc 20
aaa dddd 30
aaa bbbb 40
bbb aaaa 50
bbb cccc 60
bbb cccc 70
bbb bbbb 80
求表B
a1 a2 a3
--------------------
aaa bbbb 50
aaa cccc 20
aaa dddd 30
bbb aaaa 50
bbb cccc 130
bbb bbbb 80
------解决方案--------------------
试试这个：
select a1,a2,
SUM(a3) as a3
from A
group by a1,a2
------解决方案--------------------
create table A(a1 varchar(10), a2 varchar(10), a3 int)
insert into a
select 'aaa', 'bbbb', 10 union all
select 'aaa', 'cccc', 20 union all
select 'aaa', 'dddd', 30 union all
select 'aaa', 'bbbb', 40 union all
select 'bbb', 'aaaa', 50 union all
select 'bbb', 'cccc', 60 union all
select 'bbb', 'cccc', 70 union all
select 'bbb', 'bbbb', 80
go
select a1,a2,
SUM(a3) as a3
from A
group by a1,a2
order by a1,a2
/*
a1 a2 a3
aaa bbbb 50
aaa cccc 20
aaa dddd 30
bbb aaaa 50
bbb bbbb 80
bbb cccc 130
*/