Re: Left outer join with WHERE clause?

Поиск
Список
Период
Сортировка
От DI Hasenöhrl
Тема Re: Left outer join with WHERE clause?
Дата
Msg-id 003e01c1d65f$b9a01d80$01011eac@irina
обсуждение исходный текст
Ответ на Left outer join with WHERE clause?  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
Ответы Re: Left outer join with WHERE clause?
Список pgsql-sql
Дерево обсуждения
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 по дате отправления: