Joining Multiple Tables

You can chain multiple JOINs to connect three or more tables.

Syntax

SELECT columns
FROM table1
JOIN table2 ON table1.col = table2.col
JOIN table3 ON table2.col = table3.col;

Each JOIN connects to the growing result set.

Exercises

Tips for Multiple JOINs

1. Draw the relationships first to understand how tables connect
2. Use table aliases to keep queries readable
3. Choose the right JOIN type for each relationship:
   • INNER JOIN when both sides must have data
   • LEFT JOIN when the left side might not have matches

Free Practice