SELECT customers.customerNumber, customers.customerName, orders.orderNumber from `customers` left JOIN orders on customers.customerNumber = orders.customerNumber
