SELECT (Level 4)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| The left outer join (*=) and right outer join (=*) operators were used in SELECT statements to produce left and right outer joins, respectively. | The SQL-92-standard syntax of LEFT OUTER JOIN and RIGHT OUTER JOIN is preferred. However, join operators supported in earlier versions of Microsoft® SQL Server™ are supported.
It is recommended that you remove all references of the left outer join (*=) and right outer join (=*) operators in all SELECT statement FROM clauses and replace with references to the SQL-92-standard syntax RIGHT OUTER JOIN and LEFT OUTER JOIN. Future versions of SQL Server will support only the SQL-92-standard syntax. |