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.