Joining Three or More Tables in SQL

You can join multiple tables by chaining multiple JOIN clauses together, each with its own ON condition.

Syntax:

SELECT columnsFROM table1JOIN table2 ON table1.common_column = table2.common_columnJOIN table3 ON table2.common_column = table3.common_column-- Add more JOINs as needed;

Example:

Suppose you have three tables:

Employees

Departments

Salaries

Query: Join Employees, Departments, and Salaries

SELECT e.name, d.department_name, s.salaryFROM Employees eINNER JOIN Departments d ON e.department_id = d.department_idINNER JOIN Salaries s ON e.employee_id = s.employee_id;

Result:

Explanation:

• First join Employees with Departments on department_id.

• Then join that result with Salaries on employee_id.

• Returns employee names, their departments, and salaries.

If you want me to explain other join types or more complex queries, just ask!