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

Joining many tables

How do we join three tables in one query?

Answer options

  • By writing three separate SELECT queries below each other
  • By adding further JOIN ... ON clauses, one after another
  • By listing all tables separated by commas in SELECT
  • MySQL does not allow joining more than two tables

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