题解 | #检索每个顾客的名称和所有的订单号（一）#

方法一:


SELECT
    C.cust_name,
    O.order_num
FROM
    Customers AS C
    INNER JOIN Orders AS O ON O.cust_id = C.cust_id
ORDER BY
    C.cust_name ASC;



方法二:


SELECT
    C.cust_name,
    O.order_num
FROM
    Customers AS C,
    Orders AS O
WHERE
    O.cust_id = C.cust_id
ORDER BY
    C.cust_name ASC;