Question · SQL and MySQL course · Module 7: Joining tables (JOIN)

Value when there is no match

In a LEFT JOIN, when a row from the left table has no pair in the right one, what value will the columns from the right table take?

Answer options

  • Zero (0)
  • NULL - that is, emptiness, the absence of a value
  • An empty string ("")
  • They repeat the value from the previous row

You can check the correct answer by solving this task in the CodeWorlds game.