题解 | #确定哪些订单购买了某产品（一）#
确定哪些订单购买了 prod_id 为 BR01 的产品（一）
https://www.nowcoder.com/practice/b692b0174c0444fa9452aee2d082fbbb
select
cust_id,
order_date
from
Orders
where
order_num in (
select
order_num
from
OrderItems
where
prod_id = 'BR01'
)
order by
order_date;
子查询-单列多行-->用 in 关键字做匹配
#子查询-单列多行#SQL刷题 文章被收录于专栏
和徐一起刷题进阶！
查看26道真题和解析
投个大点的