Re: Left outer join with WHERE clause?

----- Original Message -----

From: Dan Langille

To: DI Hasenöhrl

Cc: pgsql-sql@postgresql.org

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))