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

When to use LEFT JOIN

In which case is LEFT JOIN better than INNER JOIN?

Answer options

  • When we want only pairs that definitely have a match
  • When we want to skip the left-hand table entirely
  • When we want a random order of results
  • When we also want to see readers who borrowed nothing (no matching row in wypozyczenia)

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