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

Role of the ON clause

What is the ON clause for in a JOIN query, e.g. ON k.autor_id = a.id?

Answer options

  • It sorts the result ascending by the id column
  • It limits the number of returned rows to one
  • It removes duplicates from the result
  • It defines the join condition - on which column the two tables should find each other

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