sql多表查询问题

select sum(isnull(ScrapQty,0)+isnull(Define27,0))/sum(b.define26 * b.define34 * c.srate) as yy,b.mocode ,b.invcode,sum(isnull(a.BalQualifiedQty,0)) as bb, sum(isnull(QualifiedQty,0)) as QualifiedQty,sum(isnull(ScrapQty,0)+isnull(Define27,0)) as aa,sum(isnull(ScrapQty,0)+isnull(Define27,0))/sum(isnull(a.BalQualifiedQty,0))*100 as cc,sum(isnull(a.QualifiedQty,0))/sum(isnull(a.BalQualifiedQty,0))*100 as dd from sfc_moroutingdetails a inner join jx_momorderp b on b.autoid = a.MoRoutingInspId inner jion sfc_morouting c on c.moroutingid = a.moroutingid inner join sfc_workcenter d on a.wcid = d.wcid select sum(isnull(ScrapQty,0)+isnull(Define27,0