题解 | 检索每个顾客的名称和所有的订单号(二)
检索每个顾客的名称和所有的订单号(二)
https://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
# select cust_name, order_num # from Customers C left join Orders O on C.cust_id = O.cust_id # order by # cust_name ASC; select cust_name, order_num from Customers C left join Orders O using(cust_id) order by cust_name ASC;