Jim Wright wrote:
>
> Just for clarification, is the outer join syntax that MS-SQL 2005
> deprecates (WHERE foo *= blah) non-standard...if so, was it ever
> standard?
It isn't standard and I don't think it has ever been.
> Is there ANSI compliant syntax for doing outer
> joins other than using JOIN?
There may be a workarounds but nobody in his right mind would use them. I am
writing this on the fly here and haven't tested it, but I think the following
two SQL statements are equivalent barring the presence of all NULL rows:
SELECT t1.foo, t1.bar, t2.foo, t2.bar
FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.foo = t2.foo
SELECT t1.foo, t1.bar, t2.foo, t2.bar
FROM table1 t1, table2 t2
WHERE t1.foo = t2.foo
UNION ALL
SELECT t1.foo, t1.bar, NULL, NULL
FROM table1 t1
WHERE NOT EXISTS (
SELECT 1
FROM table2
WHERE t1.foo = table2.foo)
)
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253822
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
