2022-07-12 12:28 中国石油大学（华东） 测试工程师
关注
我也可以写出子查询了😀
select cust_email from Customers
where cust_id in (
select cust_id from Orders
where order_num in (
select order_num from OrderItems
where prod_id =BR01
)
)
select cust_email from Customers
where cust_id in (
select cust_id from Orders
where order_num in (
select order_num from OrderItems
where prod_id =BR01
)
)
2022-07-12
在牛客打卡7天，今天学习：刷题 6 道/代码提交 13 次
全部评论
相关推荐
10-21 16:54
门头沟学院 Java 点赞 评论 收藏
分享
查看8道真题和解析