Question · SQL and MySQL course · Module 11: Capstone project

Which JOIN keeps unmatched left rows

Which kind of join will you use to show ALL readers, including those who borrowed nothing?

Answer options

  • INNER JOIN - returns only readers who have loans
  • CROSS JOIN - produces a Cartesian product
  • GROUP JOIN - no such join type exists
  • LEFT JOIN - keeps all rows from the left table, even without a match

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