Hi
Corelated sub-query:
UPDATE SalesSum SS
SET YTDsales=
(
SELECT sum(qty) As YTDsales
FROM ProductSales PS
WHERE OrderDate BETWEEN '1-jan-01' AND getdate()
AND PS.ProductID=SS.ProductID
)
The last line forces the inner query to recalculate for EACH product in the outer query.
Dale