子查询作为一个派生表,应该被赋予一个别名。
所以正确写法是 inner join (select order_num from OrderItems where prod_id='BR01') a ON b.order_num = a.order_num 而不是inner join (select order_num from OrderItems a where prod_id='BR01') ON
b.order_num = a.order_num
所以正确写法是 inner join (select order_num from OrderItems where prod_id='BR01') a ON b.order_num = a.order_num 而不是inner join (select order_num from OrderItems a where prod_id='BR01') ON
b.order_num = a.order_num
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fb692b0174c0444fa9452aee2d082fbbb
全部评论
相关推荐
07-03 14:11
广西大学 渠道销售 点赞 评论 收藏
分享
07-06 21:32
福州理工学院 人工智能 点赞 评论 收藏
分享