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

相关推荐

程序员小白条:三方不签,不就是纯实习骗人吗,还是小公司,没毛了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务