Multiway Joins

tags: #sql/complex_queries

A multiway join is a type of join operation that involves joining three or more tables in a single query.

It is used when you need to retrieve data from multiple tables that are related to each other by common attributes.

SELECT *
FROM table1
JOIN table2 ON table1.id = table2.table1_id
JOIN table3 ON table2.id = table3.table2_id
...;