如何用SELECT进行合并查询？

[Wocow]

有一个表t1，如下：
field1 field2 field3
a a1 1
a a1 2
a a2 3
a a2 4
b b2 5
b b2 6
c c1 7
c c2 8
c c2 9
----------------------------------------
要得到的结果如下：
field1 field2 field3
a a1 3
a a2 7
b b2 11
c c1 7
c c2 17
------------------------------------------
用一条SELECT来实现，也就是说根据FIELD2相同的合并并SUM(FIELD2)
谢谢

[Wocow]

错了，是SUM(FIELD3)

[welyngj]

select field1,field2,sum(field3) field3
from tbl
group by field1,field2

[leeboyan]

select min(field1)as field1,field2,sum(field3)as field3 from table1 group by field1

[zjcxc]

楼上已经可以了.

[victorycyz]

select min(field1) as field1,
field2,
sum(field3) as field3
from t1
group by field2

[leeboyan]

晕，打错了！
group by field2

[zjcxc]

楼上已经可以了.

[Wocow]

谢谢leeboyan(宝宝) ，我用了你的答案，是我要的结果，同实也谢谢 welyngj(平平淡淡)及其他人