Received: from email04.aon.at (WARSL401PIP2.highway.telekom.at [195.3.96.74]) by postgresql.org (Postfix) with SMTP id 9F9ED4758F1 for ; Thu, 28 Mar 2002 10:33:40 -0500 (EST) Received: (qmail 446310 invoked from network); 28 Mar 2002 15:33:44 -0000 Received: from n653p025.adsl.highway.telekom.at (HELO irina) ([62.47.25.153]) (envelope-sender ) by 172.18.5.232 (qmail-ldap-1.03) with SMTP for ; 28 Mar 2002 15:33:44 -0000 Message-ID: <005e01c1d66d$964ea3c0$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: Cc: References: <20020328130950.481C03F2D@bast.unixathome.org> Subject: Re: Left outer join with WHERE clause? Date: Thu, 28 Mar 2002 16:31:10 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005B_01C1D675.F7E9D8E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/378 X-Sequence-Number: 7252 This is a multi-part message in MIME format. ------=_NextPart_000_005B_01C1D675.F7E9D8E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Sorry, I found my mistake. It was an incorrect parenthesis. Thanks again Irina ----- Original Message -----=20 From: Dan Langille=20 To: DI Hasen=F6hrl=20 Cc: pgsql-sql@postgresql.org=20 Sent: Thursday, March 28, 2002 2:10 PM Subject: Re: [SQL] Left outer join with WHERE clause? 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)=20 Your "where" clause for an OUTER JOIN is actually the ON statement. So d= o this:=20=20 LEFT JOIN (vartikellieferantbez ON (artikel.a_nr =3D vartikellieferantbez= .a_nr AND=20 vartikellieferantbez.f_nr =3D 1))=20=20 ------=_NextPart_000_005B_01C1D675.F7E9D8E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Sorry, I found my mistake. It was an incor= rect=20 parenthesis.
 
Thanks again
Irina
----- Original Message -----
Fro= m:=20 Dan Lang= ille=20
Cc: pgsql-sql@postgresql.org
Sent: Thursday, March 28, 2002 2:1= 0=20 PM
Subject: Re: [SQL] Left outer join= with=20 WHERE clause?

On 28 Mar 2002 at 13:58, DI Hasen=F6hrl wrote:

>= It=20 doesn't work=20 too:            LE= FT=20 JOIN (vartikellieferantbez ON
> artikel.a_nr =3D vartikellieferantb= ez.a_nr=20 WHERE
> ((vartikellieferantbez.f_nr)=3D1)

Your "where" clau= se for=20 an OUTER JOIN is actually the ON statement.  So do this: =20

LEFT JOIN (vartikellieferantbez ON (artikel.a_nr =3D=20 vartikellieferantbez.a_nr  AND
vartikellieferantbez.f_nr =3D 1))=  =20

------=_NextPart_000_005B_01C1D675.F7E9D8E0--