Run SQL Update XML Package

[apastue@kingpar.com]

I am trying to update the XML package based on the section or department they are in using the Run SQL feature in the back of the aspdnsf. When I run the SQL Below the script will update all the products to this xml package not just the product with the section ID 12. It seems like it is ignoring the cross join.


UPDATE Product
SET XmlPackage = 'product.variantsinrightbar-hp.xml.config'
FROM Product CROSS JOIN
Product Section
WHERE (Section.SectionID = '12')

[jsimacek]

Try it like this:

UPDATE Product
SET XmlPackage = 'product.variantsinrightbar-hp.xml.config'
WHERE ProductID IN (SELECT ProductID FROM ProductSection WHERE SectionID=12)

[apastue@kingpar.com]

Thank you very much! That worked. I appreciate your help!!!

[jsimacek]

Very welcome!