Posted by Bart op de grote markt on 11/23/07 11:24

Hello,

I have a very simple problem which I will illustrate with an example:

I have the following records in my table:
A 1 C
A 2 C
A 3 C
B 8 K
B 9 K

I now want to group them and the result has to be:
A 1,2,3 C
B 8,9 K

So the results in the second row have to be concatenated. I guess
there is no function to do this... What is the simplest solution?

Kind regards,

Bart Warnez

• Next in forum: Re: Concat instead of SUM when grouping results
• Prev in forum: Re: Sql injecting
• Thread view: Concat instead of SUM when grouping results

[Reply to this message]