Hi,

I am trying to achieve a result equivalent to the MySQL Group_Concat() (also known as LIST() in some database SQL dialects I think) in DB2.

I have a table like this:

User ID Group
------- -------
1 Admin
1 Readers
2 Admin
3 Moderator
3 Admin
3 Readers

And I want to get a result like:

User ID Group
------- -------
1 Admin, Readers
2 Admin
3 Moderator, Admin, Readers

My DB2 SQL skills aren't very good I was wondering if anyone knows of a function equivalent to Group_Concat(), or an alternate way to get the desired result in DB2 SQL?

Any help greatly appreciated.