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

# select cust_name,order_num
# from Customers,Orders
# where Customers.cust_id=Orders.cust_id
# order by cust_name

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