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

On Sun, 26 May 2002 23:43:50 -0500, "Adam Erickson" <adamre@cox.net>
wrote:
>Given the table structure:
>string
>------
>id serial int4
>stringid int4 not null
>language varchar(32)
>content varchar(255)
>
>I'm trying to get a query that will return the
>English version of every string ("SELECT id,content FROM STRING WHERE
>language='English' and stringid=0") and their translated counterpart (say,
>Korean) which would be ("SELECT content FROM string WHERE
>stringid=ID.OF.ENGLISH.VERSION").

Adam,
no need for a subselect.  Try an outer join:

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.
Servus
 Manfred