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
全部评论
相关推荐
点赞 评论 收藏
分享
SHEIN公司福利 785人发布

