• 使用两张表的公共字段，进行正常的内连接即可。
select cust_name, order_num
from Customers c join Orders o on c.cust_id=o.cust_id
order by cust_name;