select
Customers.cust_email
from Orders
LEFT JOIN Customers ON Customers.cust_id = Orders.cust_id
LEFT JOIN OrderItems ON OrderItems.order_num = Orders.order_num
WHERE OrderItems.prod_id = 'BR01'
Customers.cust_email
from Orders
LEFT JOIN Customers ON Customers.cust_id = Orders.cust_id
LEFT JOIN OrderItems ON OrderItems.order_num = Orders.order_num
WHERE OrderItems.prod_id = 'BR01'
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F962b16554fbf4b99a87f4d68020c5bfb
全部评论
相关推荐
点赞 评论 收藏
分享
点赞 评论 收藏
分享
11-14 08:52
山东工商学院 Java
吴鹏阳:这个老师如果爱举报,你这门课确实可能挂科,这没办法。但是辅导员所谓的延毕,,怎么说呢,毕业生的就业率可是辅导员的一大考核,他咋可能为了一个逃课实习去损害自己的利益呢? 点赞 评论 收藏
分享
11-19 17:27
门头沟学院 嵌入式软件开发 点赞 评论 收藏
分享
