编写一个SQL查询，返回所有客户和他们购买的产品的名称。
SELECT customers.name, products.name 
FROM customers 
INNER JOIN purchases 
ON customers.id = purchases.customer_id 
INNER JOIN products 
ON purchases.product_id = products.id;