I have a SELECT statement that gives me a result like this:
SONG ARTIST
-----------------------------------
Song1 Artist1
Song1 Artist2
Song1 Artist3
Song2 Artist2
Song3 Artist4
Song4 Artist1
Song5 Artist4
As you can see, the same song may belong to more than one artist, and this is fine. What I would like to do is NOT to get several rows, one for each different artist, but to join all of the artists in one column and display only one row.
Is this possible?
Respectfully,
Jorge Maldonado