Re: Trouble with an outer join

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