[thelist] SQL question
rudy
r937 at interlog.com
Tue Dec 10 17:41:18 CST 2002
> why use the JOIN keyword? What's the advantage
> over a simple WHERE clause join? Is it just a matter of
> clearer syntax (for my money, the JOIN syntax isn't clearer)?
if you're using microsoft sql/server, the (+) notation is deprecated and may
not be supported soon
i find that the JOIN syntax actually is clearer, because if you join several
tables with WHERE clause syntax, some inner, some outer, it is really hard
to identify which conditions join which tables, especially if you also have
other non-joining conditions in the WHERE clause
when using JOIN syntax, each pair of tables is isolated, and the ON
condition applies only to that pair
a lot clearer, in my mind
plus, it's easier to switch back and forth from inner to outer
rudy
More information about the thelist
mailing list