From: | Martin Foster <martin(at)ethereal-realms(dot)org> |
---|---|
To: | Thomas <me(at)alternize(dot)com>, PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Trouble with an outer join |
Date: | 2005-09-26 00:40:55 |
Message-ID: | 43374397.7070201@ethereal-realms.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
me(at)alternize(dot)com wrote:
> this should work just fine:
>
> SELECT
> t.TagName AS "TagName",
> t.TagType AS "TagType",
> d.RealmName AS "RealmName"
> FROM ethereal.Tag t
> LEFT OUTER JOIN ethereal.RealmDesign d
> ON (t.TagName=d.TagName)
> WHERE t.TagType='template'
> AND (t.TagName LIKE 'Realm%'
> OR t.TagName LIKE 'Offline%')
> AND (d.RealmName='Horror' or d.RealmName IS NULL)
> ORDER BY t.TagName;
>
> cheers,
> thomas
>
What's the difference versus yours above and the one I just corrected?
Anything unexpected that I should expect from mine?
SELECT
t.TagName AS "TagName",
t.TagType AS "TagType",
d.RealmName AS "RealmName"
FROM ethereal.Tag t
LEFT OUTER JOIN ethereal.RealmDesign d
ON (t.TagName=d.TagName AND d.RealmName='Horror')
WHERE t.TagType='template'
AND (t.TagName LIKE 'Realm%'
OR t.TagName LIKE 'Offline%')
ORDER BY t.TagName;
Martin Foster
martin(at)ethereal-realms(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | me | 2005-09-26 00:47:58 | Re: Trouble with an outer join |
Previous Message | me | 2005-09-26 00:35:10 | Re: Trouble with an outer join |