|
Posted by Simon Hayes on 09/07/05 18:07
The two joins are identical, and there is no performance difference -
MSSQL will handle them in exactly the same way. The INNER JOIN / OUTER
JOIN syntax is generally preferred for several reasons: some outer
joins can't be written in 'old style' joins; separating join conditions
from filter conditions is often more readable; Microsoft has said it
may remove support for 'old style' joins in a future version of MSSQL.
If you Google for "sql 2000 ansi joins", you'll find many more detailed
discussions.
Simon
Navigation:
[Reply to this message]
|