select c.cust_name,o.order_num,oi.OrderTotal from (Customers c join Orders o) join (select order_num,quantity*item_price as OrderTotal from OrderItems) oi on c.cust_id=o.cust_id and o.order_num=oi.order_num order by cust_name,order_num asc