tsql - LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

Mots clés : sql-servertsqlleft-joinouter-joinsql-server

meilleur 1 Réponses tsql - LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

vote vote

94

<join_type> ::=      [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ <join_hint> ] ]     JOIN 
SELECT * FROM A JOIN B ON A.X = B.Y 
A LEFT JOIN B            A LEFT OUTER JOIN B A RIGHT JOIN B           A RIGHT OUTER JOIN B A FULL JOIN B            A FULL OUTER JOIN B A INNER JOIN B           A JOIN B 

Questions similaires