select  cust_name,order_num
from Customers t left join Orders t1 on t.cust_id=t1.cust_id
order by cust_name

知识点:
1、外连接的使用,识别主表
2、一般主表都放在左侧,故常用left join