Hi,

I am trying to calculate aggregate value for each mix no from each table but the value is not like expected.

Query as follows

SELECT        RawMaterialPreparation.Uniid, RawMaterialPreparation.MixNo, RawMaterialPreparation.MixQty, SUM(VacuumMixing.MixQty) AS VacuumQty, 
                         SUM(MaterialFilling.FilledQty) AS FilledQty
FROM            MaterialFilling LEFT OUTER JOIN
                         VacuumMixing ON MaterialFilling.VacuumMixId = VacuumMixing.Uniid RIGHT OUTER JOIN
                         RawMaterialPreparation ON VacuumMixing.MixId = RawMaterialPreparation.Uniid
GROUP BY RawMaterialPreparation.Uniid, RawMaterialPreparation.MixNo, RawMaterialPreparation.MixQty
ORDER BY RawMaterialPreparation.Uniid DESC