Hello,

I have a table with records like this:

Code:
-----------------
| Id  | Message |
-----------------
| 01  | Test1   |
| 02  | Test2   |
| 01  | Test3   |
| 03  | Test4   |
| 02  | Test5   |
| 01  | Test6   |
-----------------
I want to create a query that returns the results as this:

Code:
-----------------------------
| Id  | Message             |
-----------------------------
| 01  | Test1, Test3, Test6 |
| 02  | Test2, Test5        |
| 03  | Test3               |
-----------------------------
I've been trying to do it but I'm still yet to succeed. Any ideas?

Thanks