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

The word INNER

What happens to a book whose autor_id has no match in the autorzy table when we use INNER JOIN?

Answer options

  • It is shown with the author's surname set to 0
  • It disappears from the result - INNER JOIN returns only complete pairs
  • It causes an error and the whole query fails
  • It is shown twice

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