Re: Possible use of a subselect? - Mailing list pgsql-novice

From Manfred Koizar
Subject Re: Possible use of a subselect?
Date
Msg-id b7p3fuo6e36bsrcj5ln3snpet0o2f94882@4ax.com
Whole thread Raw
In response to Re: Possible use of a subselect?  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-novice
On Mon, 27 May 2002 09:44:50 +0200, I wrote:

>SELECT e.id, e.content, k.content
>FROM string e LEFT JOIN string k
>    ON e.id = k.stringid
>WHERE e.stringid = 0 AND k.language = 'Korean';
>
>HTH.
No, that doesn't help.  The "k.language = 'Korean'" part belongs into
the ON clause.  Having it in the WHERE clause makes the statement
behave like an INNER JOIN.  So Joel's answer was not only faster, but
definitely better, too.

Servus
 Manfred

pgsql-novice by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Possible use of a subselect?
Next
From: John Taylor
Date:
Subject: Full Outer Joins