[snip]
However, the LEFT and RIGHT will take me a while to figure out.
[/snip]
FROM table a LEFT OUTER JOIN table b
ON(a.column = b.column)
Just follow the order tedd, a is on the left and b is on the right
LEFT OUTER -> a -> b (what may be in a might not be in b)
a <- b <- RIGHT OUTER (what may be in b might not be in a)
FROM table a INNER JOIN table b
ON(a.column = b.column)
a -> INNER JOIN -> b (only where in a and b)
Jay:
Question -- is it redundant to say:
FROM table a LEFT OUTER JOIN table b
ON(a.column = b.column)
when "table a" appears first? Wouldn't that be the same as:
FROM table a OUTER JOIN table b
ON(a.column = b.column)
???
I'm trying to understand why use LEFT and RIGHT if the tables' order also has meaning.
Thanks for your time.
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com