题解 | #检索每个顾客的名称和所有的订单号（二）#
检索每个顾客的名称和所有的订单号（二）
https://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
SELECT
c.cust_name,
o.order_num
FROM
Customers AS c LEFT OUTER JOIN Orders AS o
ON c.cust_id = o.cust_id
ORDER BY
c.cust_name
查看8道真题和解析