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

-- 使用简单的等联结语法
select  cust_name,(
                    select order_num
                    from Orders
                    where Customers.cust_id = Orders.cust_id
                    ) as order_num
 from Customers
 order by cust_name,order_num;
 
-- 使用 INNER JOIN方式
select cust_name,order_num
 from Orders
 inner join Customers on Customers.cust_id = Orders.cust_id 
 order by cust_name,order_num;