Re: Left outer join on multiple tables - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Left outer join on multiple tables
Date
Msg-id 200401112055.33714.peter_e@gmx.net
Whole thread Raw
In response to Left outer join on multiple tables  ("David Witham" <davidw@unidial.com.au>)
List 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 ...



pgsql-sql by date:

Previous
From: "David Witham"
Date:
Subject: Left outer join on multiple tables
Next
From: beyaRecords - The home Urban music
Date:
Subject: Select into