Help in aggregate query

[somm]

Hi all,



I'm facing some problem in aggregate query.My issue is

Name Country Item Order
Sam IN QA 5
Sam IN AW 2


Results should be :

Sam IN QA,AW 7


That means concatenate fn in aggregate query.
Is there anyway to achieve this...

Thanks

[ajetrumpet]

you can do it easily without including the comma separated ITEM column:

select name, country, sum(order)

group by name, country

to include that column, you would most likely need a function call.