select mno,sum(mlprice*mlamount) from (
select f.mno,f.teamid,fc.* from stock_foremanChild fc
inner join stock_foreman f on fc.sfid=f.sfid) z
where mlsubject =2
group by mno
select f.mno,f.teamid,fc.* from stock_foremanChild fc
inner join stock_foreman f on fc.sfid=f.sfid) z
where mlsubject =2
group by mno