select cust_name, a.order_num, OrderTotal from ( select order_num, quantity*item_price OrderTotal from OrderItems ) a , ( select order_num, cust_name from Customers inner join Orders on Customers.cust_id = ...