题解 | 两种方法
#子查询 select cust_id,order_date from Orders where order_num in(select order_num from OrderItems where prod_id='BR01') order by order_date #先筛选后链接 select cust_id,order_date from orders o,orderitems oi where oi.prod_id='BR01' and o.order_num=oi.order_num order by order_date;
投递牛客等公司7个岗位 >
