pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: DI Hasenöhrl <i.hasenoehrl@aon.at>
To: match@langille.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Left outer join with WHERE clause?
Date: Thu, 28 Mar 2002 10:36:20 -0800
Message-ID: <web-841608@davinci.ethosmedia.com> (raw)
In-Reply-To: <003e01c1d65f$b9a01d80$01011eac@irina>
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
view thread (6+ messages)
Message-ID: <web-841608@davinci.ethosmedia.com> Permalink: ../web-841608@davinci.ethosmedia.com/ Also on: postgresql.org/message-id/web-841608@davinci.ethosmedia.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: josh@agliodbs.com, i.hasenoehrl@aon.at, match@langille.org Subject: Re: Left outer join with WHERE clause? In-Reply-To: <web-841608@davinci.ethosmedia.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox