Left join and Left outer join in SQL Server - Stack Overflow
As per the documentation: FROM (Transact-SQL): ::= [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ ] ] JOIN The keyword OUTER is marked as optional (enclosed in square brackets), and what this means in this case is that ......