-- 使用简单的等联结语法 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 ...