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

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

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