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.