题解 | #检索每个顾客的名称和所有的订单号（二）#
检索每个顾客的名称和所有的订单号（二）
http://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
注意用外连接
select cust_name,order_num
from Orders o
right join Customers c
on o.cust_id = c.cust_id
order by cust_name
from Orders o
right join Customers c
on o.cust_id = c.cust_id
order by cust_name
投递中国一汽等公司7个岗位 >