Here is my code:
UPDATE Product
SET ExtensionData = (SELECT i.ALT_DES
FROM itm i
WHERE sku = i.itm_cd
and i.drop_cd is null
and i.alt_des is not null)
I need to update the Product table, which is in SQL with the ALT_DES field from the ITM table in ORACLE. However, I need to connect to Oracle using OPENQUERY. How would I do this in this scenario? As simple as this probably is, it is rather urgent.
Thank you in advance,
~D