select Customers.cust_name,Orders.order_num from Customers

left join Orders

on Customers.cust_id = Orders.cust_id

order by Customers.cust_name

select Customers.cust_name,Orders.order_num from Orders right join Customers on Orders.cust_id = Customers.cust_id order by Customers.cust_name