题解 | #返回顾客名称和相关订单号#

#方法1
/*select 
    cust_name,
    order_num
from 
    Customers a,
    Orders b
where
     a.cust_id=b.cust_id
order by 
    cust_name;*/
#方法2
select 
    cust_name,
    order_num
from 
    Customers a join Orders b
where 
    a.cust_id=b.cust_id
order by 
    cust_name;