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.