SELECT
cust_id,
order_date
FROM OrderItems
LEFT JOIN Orders ON Orders.order_num = OrderItems.order_num
WHERE OrderItems.prod_id = "BR01" ORDER BY order_date ASC
cust_id,
order_date
FROM OrderItems
LEFT JOIN Orders ON Orders.order_num = OrderItems.order_num
WHERE OrderItems.prod_id = "BR01" ORDER BY order_date ASC
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F999aa31a9a504c60baa088d90d82e64d
全部评论
相关推荐
10-17 12:31
重庆交通大学 技术支持工程师 点赞 评论 收藏
分享

