题解 | #返回顾客名称和相关订单号#
返回顾客名称和相关订单号
https://www.nowcoder.com/practice/7e7bc361db6a4cb6aa35eefccfe75364
select cust_name, order_num from Customers inner join Orders using(cust_id) order by cust_name, order_num select cust_name, order_num from Customers inner join Orders on Customers.cust_id = Orders.cust_id order by cust_name, order_num
内连接用using更简洁