【来源:牛客网】
1、有两张表,如下图所示
表A(仅列出部分数据作参考)
Order_id User_id Add_time
11701245001 10000 1498882474
11701245002 10001 1498882475
表B:(仅列出部分数据作参考)
id Order_id goods_id price
1 11701245001 1001 10
2 11701245001 1002 20
3 11701245002 1001 10
问:用SQL查询 购买过goods_id 为1001的用户user_id(BCD)
- A、select user_id from A where order_id = (select order_id from B where goods_id = ‘1001’)
- B、select a.user_id from A a,B b where a.order_id=b.order_id and b.goods_id=‘1001’
- C、select user_id from A where order_id
in
(select order_id from B where goods_id = ‘1001’) - D、Select A.user_id from A
left join
Bon
A.