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

#简单的等联结语法，

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

#inner join

select c.cust_name,o.order_num from Customers c 
inner join Orders o on
c.cust_id=o.cust_id
order by c.cust_name,o.order_num;