题解 | #返回顾客名称和相关订单号#
返回顾客名称和相关订单号
https://www.nowcoder.com/practice/7e7bc361db6a4cb6aa35eefccfe75364
#方法1 /*select cust_name, order_num from Customers a, Orders b where a.cust_id=b.cust_id order by cust_name;*/ #方法2 select cust_name, order_num from Customers a join Orders b where a.cust_id=b.cust_id order by cust_name;