output query on many to many relationship into several columns

From: ssylla <stefansylla(at)gmx(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: output query on many to many relationship into several columns
Date: 2012-11-27 09:59:54
Message-ID: 1354010394000-5733692.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear list,

assuming I have the following n:n relationship:

t1:

t2:

intermediary table:
t3

How can I create an output like this:

--
View this message in context: http://postgresql.1045698.n5.nabble.com/output-query-on-many-to-many-relationship-into-several-columns-tp5733692.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

Browse pgsql-sql by date

  From Date Subject
Next Message Marcin Krawczyk 2012-11-27 10:01:00 Re: locks problem
Previous Message Marcin Krawczyk 2012-11-27 09:27:10 locks problem