How do you join more than two tables?

SQL joins · Freshers and experienced

Model answer

Chain joins: FROM orders o JOIN customers c ON c.id = o.customer_id JOIN order_items i ON i.order_id = o.id. Think of each join as producing an intermediate result. Make sure each join condition uses indexed keys.

Learn this topic

SQL JOINs: INNER JOIN and LEFT JOIN Explained in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is a join, and what types are there?
• What is the difference between INNER JOIN and LEFT JOIN?
• How do you find rows in one table that have no match in another?
• What is a self join?
• What is a CROSS JOIN?
• Why does a missing join condition create duplicate or huge results?