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.