Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id C5A2A4759C3 for ; Thu, 28 Mar 2002 13:36:22 -0500 (EST) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 841608; Thu, 28 Mar 2002 10:36:20 -0800 From: "Josh Berkus" Subject: Re: Left outer join with WHERE clause? To: DI =?ISO-8859-1?Q?Hasen=F6hrl?= , Cc: X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Thu, 28 Mar 2002 10:36:20 -0800 Message-ID: In-Reply-To: <003e01c1d65f$b9a01d80$01011eac@irina> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/382 X-Sequence-Number: 7256 DI, > I tried the Left Join with an easier query, but it still doesn't > work. Maybe you see, what I'm making wrong > select artikel.a_nr,artikel.a_bez1,artikel.a_bez2 from Artikel > LEFT JOIN (vartikellieferantbez ON (artikel.a_nr = > vartikellieferantbez.a_nr AND vartikellieferantbez.f_nr=1 )); Get rid of the extra parentheses: select artikel.a_nr,artikel.a_bez1,artikel.a_bez2 from Artikel LEFT JOIN vartikellieferantbez ON (artikel.a_nr = vartikellieferantbez.a_nr AND vartikellieferantbez.f_nr=1 ); -Josh Berkus