Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: Left outer join with WHERE clause?
Date
Msg-id web-841608@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Left outer join with WHERE clause?  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
List pgsql-sql
Tree view 
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_nrAND vartikellieferantbez.f_nr=1 );
 

-Josh Berkus

pgsql-sql by date:

Previous
From: Oleg Lebedev
Date:
Subject: Table constraints
Next
From: Stephan Szabo
Date:
Subject: Re: Table constraints