Query

[J]

I'm trying to combine 2 queries but I don't have the correct syntax here
because the ChemAmt and SolventsUsed are being doubled. Can some one point
out my error.
SELECT DISTINCTROW tblPrecursorBatches.PrecursorBatchID,
Sum(tblPrecursorComp.AmtUsed) AS ChemAmt, Sum(tblPrecSolvents.AmtUsed) AS
SolventsUsed, [ChemAmt]+[SolventsUsed] AS TotalPrecursorMass
FROM (tblPrecursorBatches INNER JOIN tblPrecursorComp ON
tblPrecursorBatches.ID = tblPrecursorComp.Precursor_ID) INNER JOIN
tblPrecSolvents ON tblPrecursorBatches.ID = tblPrecSolvents.Precursor_ID
GROUP BY tblPrecursorBatches.PrecursorBatchID;