select cust_name,O.order_num ,quantity*item_price as OrderTotal from Customers C, Orders O, OrderItems OI where C.cust_id=O.cust_id and O.order_num=OI.order_num order by cust_name,order_num
2

相关推荐

牛客963010790号:为什么还要收藏
点赞 评论 收藏
分享
牛客网
牛客企业服务