SELECT c.name, o.product FROM customers c JOIN orders o ON c.id = o.customer_id WHERE o.id IS NOT NULL;