Left outer join on multiple tables

From: "David Witham" <davidw(at)unidial(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Left outer join on multiple tables
Date: 2004-01-09 05:23:54
Message-ID: CFA248776934FD43847E740E43C346D199DB51@ozimelb03.ozicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-01-09 05:49:45 Re: Date select question...
Previous Message Robert Creager 2004-01-09 04:59:58 Re: grouping by date