What is the difference between a LEFT JOIN and a LEFT OUTER JOIN?
SQLLevel: IntermediateJOINs Deep Dive
What is the difference between a LEFT JOIN and a LEFT OUTER JOIN?
Hints
- Write the join keys and relationship cardinality.
- What happens to duplicates and unmatched rows? Check WHERE versus ON.
Answer
They're identical. The OUTER keyword is optional. Same goes for INNER JOIN vs JOIN. Most people drop the OUTER and INNER keywords in practice.
Source and licence: SQL Interview Questions — Arda Kocadoru · MIT