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

Reply via email to