Hope this query would solve your problem!!

select Order_number,Total_Sale_amt, sum(Sale_amt) from

ORDERS_TABLE OT

inner join ORDERS_DETAILS OD

on OT.Order_number = OD.Order_number

group by Order_number,Total_Sale_amt