SELECT cust_name, order_num FROM Customers C LEFT JOIN Orders O on C.cust_id=O.cust_id ORDER BY cust_name