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

From David Witham
Subject Left outer join on multiple tables
Date
Msg-id CFA248776934FD43847E740E43C346D199DB51@ozimelb03.ozicom.com
Whole thread Raw
Responses Re: Left outer join on multiple tables
List 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
intoa temp table and then another join from the temp table to the third table? I can't seem to work out the syntax from
theUser Guide. 

Thanks,

David Witham
Telephony Platforms Architect
Unidial
Ph: 03 8628 3383
Fax: 03 8628 3399



pgsql-sql by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Different query results in psql and Perl DBI with Postgres 7.2.1
Next
From: Peter Eisentraut
Date:
Subject: Re: Left outer join on multiple tables