Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by postgresql.org (Postfix) with ESMTP id CE51947594C for ; Thu, 28 Mar 2002 08:10:19 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 481C03F2D; Thu, 28 Mar 2002 08:09:50 -0500 (EST) From: "Dan Langille" Organization: DVL Software Limited To: "=?ISO-8859-1?Q?DI_Hasen=F6hrl?=" Date: Thu, 28 Mar 2002 08:10:21 -0500 MIME-Version: 1.0 Subject: Re: Left outer join with WHERE clause? Reply-To: match@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: <20020328130950.481C03F2D@bast.unixathome.org> X-Archive-Number: 200204/21 X-Sequence-Number: 7286 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))