我也可以写出子查询了😀
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 次
全部评论
相关推荐
07-09 13:51
门头沟学院 Java 还处在暑期实习上岸后的摆烂状态实习:杂活多,产出少,文档也没偷学多少八股:忘的差不多了项目:有实习就不会问玩具项目了吧力扣:我可以说我连hot 100都没刷完吗国企:从零开始准备论文:没着落
回收旧报纸:世另我,只是我比你更烂一些,没找到实习,你起码还有实习的,秋招猛猛冲,加油
点赞 评论 收藏
分享