Question · SQL and MySQL course · Module 7: Joining tables (JOIN)
What INNER JOIN does
Which rows will an INNER JOIN of two tables return?
Answer options
- Only those pairs of rows that match each other according to the ON condition
- All rows from both tables, even without a match
- Only the rows from the first table
- Only the rows that have no match
You can check the correct answer by solving this task in the CodeWorlds game.