题解 | 检索每个顾客的名称和所有的订单号(一)
select
cust_name,
order_num
from
Customers c
inner join Orders o on c.cust_id = o.cust_id
order by
cust_name
select
cust_name,
order_num
from
Customers c
inner join Orders o on c.cust_id = o.cust_id
order by
cust_name
相关推荐
查看17道真题和解析
查看16道真题和解析