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

Which JOIN keeps all rows

We want a list of ALL readers together with their loan dates, without losing those who borrowed nothing. Which join should we use (czytelnicy on the left)?

Answer options

  • INNER JOIN - it shows only readers with loans
  • A plain SELECT without any JOIN
  • RIGHT JOIN with the czytelnicy table on the left
  • LEFT JOIN - it keeps all readers, and a missing loan gives NULL

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