Skip to content
Quantoros

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

Related questions