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

相关推荐

04-24 18:13
南京大学 Java
不吃酸菜血肠:看力竭了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务