SELECT customers.name, orders.order_date FROM customers JOIN orders ON customers.customer_id = orders.customer_id; This would return the names of customers and the dates of their orders.