I have 3 tables.
I want update 2 fields in the Nop_Product table with data from the TempOne table,
based on the SKU field matching in the Nop_ProductVariant table.
(Brand, MetaTitle2, and SKU in TempOne table)
SET SEName2 = Brand, MetaTitle2 = Category
But the Nop_ProductVariant table has the SKU field that matches the
SKU field in the TempOne table :
WHERE Nop_Product.[ProductId] IN
(SELECT Nop_ProductVariant.ProductId FROM Nop_ProductVariant
then join the SKU from TempOne table here ???
How do I do this? thanks