OpenOffice.info

Code: Alles auswählen

ID | c1 | c2 |
2    xx    yy
3    xy    yz
4    yd    yf

Code: Alles auswählen

IDo  |  titel | content
2        t1     ct12
2        t2     ct22
2        t3     ct32 
3        t1     ct13
3        t3     ct33
4        t2     ct24
4        t3     ct34

Code: Alles auswählen

ID | c1 | c2 |  t1  |  t2  |  t3
2    xx    yy   ct12  ct22  ct32
3    xy    yz   ct13        ct33
4    yd    yf         ct24  ct34

Code: Alles auswählen

select t1.*, array_to_string(array_agg(case when t2.titel = 't1' then t2.content else null end),',') as t1, array_to_string(array_agg(case when t2.titel='t2' then t2.content else null end),',') as t2, array_to_string(array_agg(case when t2.titel = 't3' then t2.content else null end),',') as t3 from t1 left join t2 on t1.id=t2.ido group by 1,2,3;
 id | c1 | c2 |  t1  |  t2  |  t3
----+----+----+------+------+------
  2 | xx | yy | ct12 | ct22 | ct32
  3 | xy | yz | ct13 |      | ct33
  4 | yd | yf |      | ct24 | ct34
(3 Zeilen)

Code: Alles auswählen

SELECT "a".*, "b"."t1", "c"."t2", "d"."t3" FROM "Tabelle1" "a"
LEFT JOIN  (SELECT "IDo", "content" AS "t1" FROM "Tabelle2" WHERE "titel" = 't1') "b" ON "a"."ID" = "b"."IDo"
LEFT JOIN  (SELECT "IDo", "content" AS "t2" FROM "Tabelle2" WHERE "titel" = 't2') "c" ON "a"."ID" = "c"."IDo"
LEFT JOIN  (SELECT "IDo", "content" AS "t3" FROM "Tabelle2" WHERE "titel" = 't3') "d" ON "a"."ID" = "d"."IDo"