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