Nested Loop Join — for each outer row, scan the inner side

SELECT c.name, o.total FROM customers c JOIN orders o ON o.customer_id = c.id;