Question · SQL and MySQL course · Module 7: Joining tables (JOIN)
The IS NULL filter after LEFT JOIN
Why do we add WHERE w.id IS NULL to the query czytelnicy c LEFT JOIN wypozyczenia w?
Answer options
- To sort the result by the id column
- To show only readers with many loans
- To keep only readers without any loan (an empty match)
- To remove the id column from the result
You can check the correct answer by solving this task in the CodeWorlds game.