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