笨办法
SELECT
Orders.cust_id,
Orders.order_date
FROM Orders
LEFT JOIN OrderItems ON OrderItems.order_num = Orders.order_num
WHERE OrderItems.prod_id = 'BR01'
SELECT
Orders.cust_id,
Orders.order_date
FROM Orders
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%2Fb692b0174c0444fa9452aee2d082fbbb
全部评论
相关推荐
02-27 14:25
咸阳师范学院 运营 点赞 评论 收藏
分享
查看24道真题和解析 点赞 评论 收藏
分享
