| From: | DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at> |
|---|---|
| To: | <match(at)langille(dot)org> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Left outer join with WHERE clause? |
| Date: | 2002-03-28 15:31:10 |
| Message-ID: | 005e01c1d66d$964ea3c0$01011eac@irina |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Sorry, I found my mistake. It was an incorrect parenthesis.
Thanks again
Irina
----- Original Message -----
From: Dan Langille
To: DI Hasenöhrl
Cc: pgsql-sql(at)postgresql(dot)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))
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2002-03-28 15:35:25 | Re: function error |
| Previous Message | DI Hasenöhrl | 2002-03-28 13:51:56 | Re: Left outer join with WHERE clause? |