Question · SQL and MySQL course · Module 7: Joining tables (JOIN)
RIGHT JOIN versus LEFT JOIN
How do we get the same result as RIGHT JOIN using only LEFT JOIN?
Answer options
- Add the word REVERSE at the end
- Swap the tables - put what was on the right onto the left
- Remove the ON clause
- It cannot be done - they are completely unrelated operations
You can check the correct answer by solving this task in the CodeWorlds game.