select a.cust_name   ,b.order_num   ,(select sum(quantity*item_price) OrderTotal from OrderItems c where c.order_num=b.order_num)    from Customers a,Orders b    where b.cust_id=a.cust_id    order by a.cust_name