数据合并的问题?

[userxk]

有这样几条记录：
tyep id CountNum ListenNum
a 1 3 2
a 1 5 4
b 2 3 1

如何将它合并为如形式：
tyep id CountNum ListenNum
a 1 8 6
b 2 3 1

[lsxaa]

select tyep,id,CountNum=sum(CountNum),ListenNum=sum(ListenNum)
from t
group by tyep,id

[zjcxc]

select tyep,id
,CountNum=sum(CountNum)
,ListenNum=sum(ListenNum)
from 表
group by tyep,id

[userxk]

这里的"表"是一个select查询结果集,应该如何办?

[friendly_2008]

select 别名.tyep,别名.id
,CountNum=sum(别名.CountNum)
,ListenNum=sum(别名.ListenNum)
from (结果集)别名
group by 别名.tyep,别名.id

[userxk]

很麻烦呀!