题解 | #检索每个顾客的名称和所有的订单号（二）#
检索每个顾客的名称和所有的订单号（二）
http://www.nowcoder.com/practice/4e73c4e770b941c9abc60814601ed498
select Customers.cust_name,Orders.order_num from Customers
left join Orders
on Customers.cust_id = Orders.cust_id
order by Customers.cust_name
select Customers.cust_name,Orders.order_num from Orders right join Customers on Orders.cust_id = Customers.cust_id order by Customers.cust_name
三奇智元机器人科技有限公司公司福利 70人发布