Merge Join
— walk two sorted inputs in lockstep
← all topics
SELECT
c.name, o.total
FROM
customers c
JOIN
orders o
ON
o.customer_id = c.id
ORDER BY
c.id;
Outer (sorted by id)
idle
Output
Inner (sorted by customer_id)