select C.cust_name,order_num from Customers C left join Orders O on C.cust_id = O.cust_id order by cust_name;