SELECT (Level 4)

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.


Show: