题解 | 两种方法
#子查询 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;
查看9道真题和解析
