Re: Left outer join with WHERE clause?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>, <match(at)langille(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Left outer join with WHERE clause?
Date: 2002-03-28 18:36:20
Message-ID: web-841608@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

DI,

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

Get rid of the extra parentheses:

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

-Josh Berkus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Lebedev 2002-03-28 19:00:47 Table constraints
Previous Message Travis Hoyt 2002-03-28 15:51:37 Re: function error