[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] output query on many to many relationship into several columns
From:       ssylla <stefansylla () gmx ! de>
Date:       2012-11-27 9:59:54
Message-ID: 1354010394000-5733692.post () n5 ! nabble ! com
[Download RAW message or body]

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.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


[prev in list] [next in list] [prev in thread] [next in thread]