题解 | #检索每个顾客的名称和所有的订单号(一)#
检索每个顾客的名称和所有的订单号(一)
https://www.nowcoder.com/practice/0a876520bd314505b787648e331f5e81
select
t1.cust_name ,
t2.order_num
from Customers t1
inner join Orders t2
on t2.cust_id = t1.cust_id
order by t1.cust_name
/*SQL*/;
检索每个顾客的名称和所有的订单号(一)
https://www.nowcoder.com/practice/0a876520bd314505b787648e331f5e81
select
t1.cust_name ,
t2.order_num
from Customers t1
inner join Orders t2
on t2.cust_id = t1.cust_id
order by t1.cust_name
/*SQL*/;
相关推荐