Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by postgresql.org (Postfix) with ESMTP id D212847594C for ; Thu, 28 Mar 2002 08:21:51 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 22CCF3F2D; Thu, 28 Mar 2002 08:21:23 -0500 (EST) From: "Dan Langille" Organization: DVL Software Limited To: "=?ISO-8859-1?Q?DI_Hasen=F6hrl?=" Date: Thu, 28 Mar 2002 08:21:52 -0500 MIME-Version: 1.0 Subject: Re: Left outer join with WHERE clause? Reply-To: dan@langille.org Cc: In-reply-to: <002b01c1d658$4612fc40$01011eac@irina> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body Message-Id: <20020328132123.22CCF3F2D@bast.unixathome.org> X-Archive-Number: 200203/376 X-Sequence-Number: 7250 [resent with a valid FROM: address] On 28 Mar 2002 at 13:58, DI Hasen=F6hrl wrote: > It doesn't work too: LEFT JOIN (vartikellieferantbez ON > artikel.a_nr =3D vartikellieferantbez.a_nr WHERE > ((vartikellieferantbez.f_nr)=3D1) Your "where" clause for an OUTER JOIN is actually the ON statement. So do this: LEFT JOIN (vartikellieferantbez ON (artikel.a_nr =3D vartikellieferantbez.a_nr AND vartikellieferantbez.f_nr =3D 1)) -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples