[Stackoverflow] [Progress OpenEdge ABL] Progress 12.2 - Concat rows with same ID

[JeromeF99]

I use the database Progress 12.2 and I want to group rows with same id

For example I have

ID Code
1   PB
1   RO

And I want :

ID Code
1   PB, RO

This is my request :

SELECT id, code FROM table WHERE table.id = 1

I tried String_agg, Group_concat ... but nothing works. Anyone has an idea ?

Regards,

Continue reading...