Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D380447648A for ; Wed, 15 Jan 2003 10:09:18 -0500 (EST) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id 83283476F3F for ; Wed, 15 Jan 2003 10:01:41 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 7AC473D28; Wed, 15 Jan 2003 10:01:45 -0500 (EST) From: "Dan Langille" To: "Marko Asplund" Date: Wed, 15 Jan 2003 10:01:45 -0500 MIME-Version: 1.0 Subject: Re: Oracle outer join porting question Cc: Message-ID: <3E253189.3484.2EE06930@localhost> In-reply-to: <81132473206F3A46A72BD6116E1A06AE3EC030@black.aprote.com> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/216 X-Sequence-Number: 11081 On 15 Jan 2003 at 16:40, Tambet Matiisen wrote: > Try this: > > SELECT doc.id,doc.title,sub.user_id,sub.operation > FROM document doc LEFT OUTER JOIN document_subscription sub > ON sub.document_id = doc.id AND sub.user_id = 6; FWIW: test=# SELECT doc.id,doc.title,sub.user_id,sub.operation test-# FROM document doc LEFT OUTER JOIN document_subscription sub test-# ON sub.document_id = doc.id AND sub.user_id = 6; id | title | user_id | operation ----+-------+---------+----------- 1 | doc1 | | 2 | doc2 | 6 | op2 4 | doc4 | | -- Dan Langille : http://www.langille.org/