题解 | 检索每个顾客的名称和所有的订单号(二)
检索每个顾客的名称和所有的订单号(二)
https://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
select C.cust_name, O.order_num from Customers as C left join Orders as O on C.cust_id = O.cust_id order by C.cust_name;
检索每个顾客的名称和所有的订单号(二)
https://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
select C.cust_name, O.order_num from Customers as C left join Orders as O on C.cust_id = O.cust_id order by C.cust_name;
相关推荐
查看8道真题和解析