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

/**
select
    c.cust_name cust_name,
    o.order_num order_num
from 
    Customers c, Orders o
where
    c.cust_id = o.cust_id
order by
    cust_name,order_num;
*/

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