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

# #INNER JOIN 写法
# select a.cust_name,
# b.order_num 
# from Customers a
# inner join Orders b
# on a.cust_id = b.cust_id
# order by a.cust_name asc;

#简单的等联结语法
select a.cust_name,
b.order_num
from Customers a,Orders b
where a.cust_id = b.cust_id
order by a.cust_name asc;