select Customers.cust_name, Orders.order_num, (OrderItems.quantity*OrderItems.item_price) as OrderTotal from Orders left join Customers on Customers.cust_id=Orders.cust_id left join OrderItems on OrderItems.order_num=Orders.order_num order by Customers.cust_name,OrderItems.order_num