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