Postgres Pro
Downloads
Home   >   mailing lists

Joining several rows into only one - Mailing list pgsql-sql

From JORGE MALDONADO
Subject Joining several rows into only one
Date
Msg-id CAAY=A79L1zaxcSoCUzssHogoezEneWA=ZUEu3veHLk86K-EG_g@mail.gmail.com
Whole thread Raw
Responses Re: Joining several rows into only one
Re: Joining several rows into only one
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: select on many-to-many relationship
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: Joining several rows into only one