Re: Possible use of a subselect? - Mailing 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