我也可以写出子查询了😀
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 次
全部评论
相关推荐
06-02 15:17
门头沟学院 Java 点赞 评论 收藏
分享