LEFT JOIN and LEFT OUTER JOIN works exactly the same way.
Which means the keyword OUTER has no effect or it is optional.
Why do we include a keyword which has no effect in execution?
Why do we need an optional keyword OUTER in SQL?
Viewed 822
1 Answers
It is optional, I always assumed that it was originally there as its more descriptive.
However it doesn't actually mean anything as a join is either inner, left, right or full - so the outer key word can be inferred to be relevant for all but inner joins.
Related