Posted by Erland Sommarskog on 09/09/05 00:39

Simon Hayes (sql@hayes.ch) writes:
> 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.

For old style *outer* joins that is.

The syntax that Mike used is part of the ANSI standard, and MS have
no plans to remove support for that syntax.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]