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.