题解 | 检索每个顾客的名称和所有的订单号(一)
检索每个顾客的名称和所有的订单号(一)
https://www.nowcoder.com/practice/0a876520bd314505b787648e331f5e81
select C.cust_name, O.order_num from Customers as C join Orders as O on C.cust_id = O.cust_id order by C.cust_name;
检索每个顾客的名称和所有的订单号(一)
https://www.nowcoder.com/practice/0a876520bd314505b787648e331f5e81
select C.cust_name, O.order_num from Customers as C join Orders as O on C.cust_id = O.cust_id order by C.cust_name;
相关推荐