笨办法
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
全部评论
相关推荐
Yilena:还是决定再沉淀沉淀了,小小海投了一下,入场晚了现在基本没有寒假实习岗了,几乎都是日常,而且岗位也比较少,质量也不高。还是等年后冲击一下中大厂的日常看看吧
点赞 评论 收藏
分享
查看11道真题和解析
