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