题解 | #返回顾客名称和相关订单号#

方法一:

SELECT

    C.cust_name,

    O.order_num

FROM

    Customers AS C,

    Orders AS O

WHERE

    C.cust_id = O.cust_id

ORDER BY

    C.cust_name ASC,

    O.order_num ASC;

方法二:

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,

    O.order_num ASC;