help merge rows in query

[pika2112]

HI


having a query result like this:

Mealcode Day Patient code
E01 2 234
E01 2 654
E01 2 987
E03 3 256
E03 3 234
E03 3 123

This query says to me that in the day 2 the meal is going to be the meal with the code E01 and the patients with the code 234, 654 and 987 cant eat it. them the same for they 3, 4, etc.

If it would be possible I liked something like:

Mealcode Day Patient code
E01 2 234, 654, 987

So that I have a row for each day and not like a row for each patient a day.

Thanks for the help!

[pbaldy]

One way:

http://allenbrowne.com/func-concat.html