X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 432AED1B43A for ; Fri, 9 Jan 2004 05:24:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 46816-04 for ; Fri, 9 Jan 2004 01:23:57 -0400 (AST) Received: from ozimelb03.ozicom.com (unknown [203.185.247.100]) by svr1.postgresql.org (Postfix) with ESMTP id 75B53D1B438 for ; Fri, 9 Jan 2004 01:23:55 -0400 (AST) content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Left outer join on multiple tables Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Fri, 9 Jan 2004 16:23:54 +1100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Left outer join on multiple tables Thread-Index: AcPWcMXc99vXXoYFSfCttxAVyQuBBw== From: "David Witham" To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/83 X-Sequence-Number: 16476 Hi all, Is there a way to do left outer joins on more than 2 tables at once (3 in m= y case)? Or do I have to do the first join into a temp table and then anoth= er join from the temp table to the third table? I can't seem to work out th= e syntax from the User Guide. Thanks, David Witham Telephony Platforms Architect Unidial Ph: 03 8628 3383 Fax: 03 8628 3399