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

方法一

就是使用 where 进行简单的联结

select cust_name,order_num
from Customers,Orders
where Customers.cust_id=Orders.cust_id
order by cust_name,order_num;

方法二

使用内联结

select cust_name,order_num
from Customers
INNER JOIN Orders ON Orders.cust_id=Customers.cust_id
order by cust_name,order_num;