Trying to find the difference between two sub-totals (sales - credits)

Hi!

How about this:

SELECT TotalSales-TotalCredits
FROM(

SELECT T0.ItemCode, SUM(T0.LineTotal) TotalSales
FROM INV1 T0
WHERE T0.ItemCode = 'ACR2401010'
GROUP BY T0.ItemCode

) a
INNER JOIN
(
SELECT T1.ItemCode, SUM(T1.LineTotal) TotalCredits
FROM RIN1 T1
WHERE T1.ItemCode = 'ACR2401010'
GROUP BY T1.ItemCode
) b
ON a.ItemCode = b.ItemCode

---

Alexander Karavaev, PMP, MCITP, MCTS