Received: from email01.aon.at (WARSL401PIP2.highway.telekom.at [195.3.96.74]) by postgresql.org (Postfix) with SMTP id E2261475968 for ; Thu, 28 Mar 2002 08:54:27 -0500 (EST) Received: (qmail 579196 invoked from network); 28 Mar 2002 13:54:30 -0000 Received: from n653p025.adsl.highway.telekom.at (HELO irina) ([62.47.25.153]) (envelope-sender ) by qmail1rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 28 Mar 2002 13:54:30 -0000 Message-ID: <003e01c1d65f$b9a01d80$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 14:51:56 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003B_01C1D668.1B216200" 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/377 X-Sequence-Number: 7251 This is a multi-part message in MIME format. ------=_NextPart_000_003B_01C1D668.1B216200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you very much, for your advice, but something is still wrong, because= it doesn't work. I get the following message: parse error at or near "on" I tried the Left Join with an easier query, but it still doesn't work. Mayb= e you see, what I'm making wrong select artikel.a_nr,artikel.a_bez1,artikel.a_bez2 from Artikel=20 LEFT JOIN (vartikellieferantbez ON (artikel.a_nr =3D vartikellieferantbez= .a_nr AND vartikellieferantbez.f_nr=3D1 )); Many thanks, 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_003B_01C1D668.1B216200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you very much, for your advice, but = something=20 is still wrong, because it doesn't work.
 
I get the following message: parse= error at=20 or near "on"
 
I tried the Left Join with an easier query= , but it=20 still doesn't work. Maybe you see, what I'm making wrong
select artikel.a_nr,artikel.a_bez1,artik= el.a_bez2=20 from Artikel
LEFT JOIN (vartikellieferantbez ON (artikel.a_nr =3D=20 vartikellieferantbez.a_nr AND vartikellieferantbez.f_nr=3D1 ));
 
Many thanks,
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_003B_01C1D668.1B216200--