题解 | #检索每个顾客的名称和所有的订单号（一）#
检索每个顾客的名称和所有的订单号（一）
https://www.nowcoder.com/practice/0a876520bd314505b787648e331f5e81
select cust_name, order_num from Customers c inner join Orders o on c.cust_id=o.cust_id group by cust_name, order_num # 由于是顾客号与订单号一一对应，故该分组也可以不加 order by cust_name;
这样才显得专业