Search code examples
sqlsql-serveransi-sql

Why is OUTER optional in SQL Server?


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?


Solution

  • 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.