主题：2个表通过SQL组合以后如何求和

Select (SELECT from_id FROM crm_opportuniy WHERE opp_id = crm_sale.opp_id) as 来源,sale_id,totalmoeny from crm_sale

SUM(totalmoeny )  的SQL 语句怎么写