Question · SQL and MySQL course · Module 7: Joining tables (JOIN)

INNER versus LEFT JOIN

What is the key difference between INNER JOIN and LEFT JOIN?

Answer options

  • INNER and LEFT JOIN always return exactly the same rows
  • LEFT JOIN does not need an ON clause, but INNER JOIN does
  • INNER JOIN works only on a single table
  • INNER returns only matched pairs, while LEFT keeps all rows from the left table (with NULL when there is no match)

You can check the correct answer by solving this task in the CodeWorlds game.