Chaining two JOINs across three tables

Question

Accepted Answer

Chaining JOINs is how you traverse relationships across multiple tables. The first JOIN links orders to customers via customer_id = c.id. The second JOIN links the same orders row to products via product_id = p.id. The result for the single order is Alice | Widget.