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.