Hi all,
I want to make an aggregate function that concatenates strings from a
certain column into one cell in a group by clause.
For example I have the following table :
Type Text
=================
1 text1
2 text2
1 text3
3 text4
2 text5
I need a query that group by type and concats the text columns to
produce something like the following :
1 text1, text3
2 text2, text5
3 text4
I am aware that this can be done through recursive joins but this is too
complicated and heavy.
Any suggestions?
Regards