Referring to this post on Stack Overflow
Why was the key word OUTER
made optional (in LEFT OUTER JOIN
etc) - if it had been a required word then scripts written on SQL Server would be more standard compliant?
It is optional in ANSI SQL, not just in T-SQL.
And it is optional, because the joins are unambiguous without the use of OUTER
.