Multi-table Joins

You can join three or more tables in a single SQL query by chaining multiple JOIN operations.

This is common in normalized databases where data is separated across related tables.

By default, when you just write JOIN without specifying the type, most SQL databases interpret it as an INNER JOIN.

Here is the syntax for a multi-table join:

Copy
SELECT ...
FROM table1
JOIN table2 ON ...
JOIN table3 ON ...;

Each JOIN connects one additional table to the growing result set.

Make sure each join condition (ON ...) clearly defines how the tables relate.

As an example, let's say we have the following tables:

students

enrollments

classes

Below is an example of a multi-table join between the students, enrollments, and classes tables.

Copy
SELECT students.name, classes.class_name
FROM students
JOIN enrollments ON students.student_id = enrollments.student_id
JOIN classes ON enrollments.class_id = classes.class_id;

This query connects students to their enrollments, then maps those to class names.

Use multi-table joins when:

• You need a complete view across multiple related tables
• You're working with a normalized schema
• You're building reports that require joined context

Tip: Use clear and descriptive aliases to keep your queries readable.