pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLeft outer join on multiple tables
2+ messages / 2 participants
[nested] [flat]
* Left outer join on multiple tables
@ 2004-01-09 05:23 David Witham <davidw@unidial.com.au>
0 siblings, 1 reply; 2+ messages in thread
From: David Witham @ 2004-01-09 05:23 UTC (permalink / raw)
To: pgsql-sql
Hi all,
Is there a way to do left outer joins on more than 2 tables at once (3 in my case)? Or do I have to do the first join into a temp table and then another join from the temp table to the third table? I can't seem to work out the syntax from the User Guide.
Thanks,
David Witham
Telephony Platforms Architect
Unidial
Ph: 03 8628 3383
Fax: 03 8628 3399
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Left outer join on multiple tables
@ 2004-01-11 19:55 Peter Eisentraut <peter_e@gmx.net>
parent: David Witham <davidw@unidial.com.au>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2004-01-11 19:55 UTC (permalink / raw)
To: David Witham <davidw@unidial.com.au>; pgsql-sql
David Witham wrote:
> Is there a way to do left outer joins on more than 2 tables at once
> (3 in my case)? Or do I have to do the first join into a temp table
> and then another join from the temp table to the third table? I can't
> seem to work out the syntax from the User Guide.
SELECT * FROM a LEFT JOIN b ON (...) LEFT JOIN c ON c WHERE ...
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-11 19:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-09 05:23 Left outer join on multiple tables David Witham <davidw@unidial.com.au>
2004-01-11 19:55 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox