Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 4411747643F for ; Thu, 30 May 2002 13:59:39 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 612B8476355 for ; Thu, 30 May 2002 13:42:24 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4UHfxW01974; Thu, 30 May 2002 13:41:59 -0400 (EDT) To: Wei Weng Cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: Can you help with this JOIN? In-reply-to: <1022779024.32670.7.camel@Monet> References: <20020529100354.M33333-100000@megazone23.bigpanda.com> <1022779024.32670.7.camel@Monet> Comments: In-reply-to Wei Weng message dated "30 May 2002 13:16:58 -0400" Date: Thu, 30 May 2002 13:41:59 -0400 Message-ID: <1971.1022780519@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/317 X-Sequence-Number: 7952 Wei Weng writes: > But how do I write the LEFT OUTER JOIN if I don't do explicit JOINs on > the other tables? See the manual: there's a relevant example near the bottom of http://www.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html but you'd do well to study that whole page... regards, tom lane