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