怎样排列结果集?

[danieltang]

S a 15 a1
S a 8 a2
S a 15 a3
S a 8 a4
能否排列为:

S a 15 a1+a3 8 a2+a4

[beckhambobo]

select a.col1,a.col2,a.col3,a.col3_sum,b.col4,b.col4_sum from (select col1,col2,col3,sum(col4) col3_sum from table where col3=15 group by col1,col2,col3) a,(select col3 col4,sum(col4) col4_sum from where col3=8 talbe group by col1,col2,col3) b