Code: Alles auswählen
select
t1.*,
t2.*
t3.*
from
tabelle1 t1 left outer join tabelle2 t2 on t1.x = t2.y
tabelle1 t1 left outer join tabelle3 t3 on t1.x = t3.z
;
Code: Alles auswählen
select
t1.*,
t2.*
t3.*
from
tabelle1 t1 left outer join tabelle2 t2 on t1.x = t2.y
t1 left outer join tabelle3 t3 on t1.x = t3.z
;