Can you join Productss (is it really spelled with two S's :hehe:) to the select statement i.e.: UPDATE pdt

SET pdt.HotLeadParticipant=0

FROM

dbo.ValidProducts vp

INNER JOIN dbo.BoxProducts ap

ON vp.BoxProductID = ap.BoxProductID

INNER JOIN dbo.Boxs a

ON ap.BoxID = a.BoxID

INNER JOIN dbo.tblProducts p

ON vp.ProductID = p.ProductsD

INNER JOIN dbo.Productss pdt

ON vp.ProductID = pdt.ProductID

WHERE a.BoxID IN (297,

318,

337,

354,

397,

398,

504,

535,

557,

604,

733)