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.