Hello,

I am trying to return multiple results into a single field. Does anyone know the easiest way to to this? Can it be done with a standard query or will I need to use a stored procedure. I can do it in other database but haven't found a way in Informix. I have included a sample below:

Sample Table structure

id order facility
1 1234 2
2 1235 2
3 1236 3
4 1237 3
5 1238 4


Desired results

orders facility
1234,1235 2
1236,1237 3
1238 4


Thank you for your time,

Michael