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

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