题解 | #检索每个顾客的名称和所有的订单号（二）#
检索每个顾客的名称和所有的订单号（二）
https://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
select
t1.cust_name,
t2.order_num
from
Customers t1
left join
Orders t2
on
t1.cust_id = t2.cust_id
order by
t1.cust_name
查看8道真题和解析