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.
SET XmlPackage = 'product.variantsinrightbar-hp.xml.config'
FROM Product CROSS JOIN
WHERE (Section.SectionID = '12')