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

使用left join，保留左表所有数据，如果右表没有对应的数据则以NULL对应