Postgres Pro
Downloads
Home   >   mailing lists

Re: Left outer join with WHERE clause? - Mailing list pgsql-sql

From DI Hasenöhrl
Subject Re: Left outer join with WHERE clause?
Date
Msg-id 003e01c1d65f$b9a01d80$01011eac@irina
Whole thread Raw
In response to Left outer join with WHERE clause?  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
Responses Re: Left outer join with WHERE clause?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view
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. 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 ));
 
Many thanks,
Irina
----- Original Message -----
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öhrl wrote:

> It doesn't work too:            LEFT JOIN (vartikellieferantbez ON
> artikel.a_nr = vartikellieferantbez.a_nr WHERE
> ((vartikellieferantbez.f_nr)=1)

Your "where" clause for an OUTER JOIN is actually the ON statement.  So do this: 

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

pgsql-sql by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: Left outer join with WHERE clause?
Next
From: DI Hasenöhrl
Date:
Subject: Re: Left outer join with WHERE clause?