CODEWITHSUNDEEP
sqlteradata
sumanjit roy
sumanjit roy

Reputation: 21

Update columns In a Teradata Table using data from another table

I have seen many posts and followed the syntax to write the below query. But it is still given the error "Column/Parameter wm_ad_hoc.temp.temp does not exist"

Please assist in figuring out what am I doing wrong here.

UPDATE temp 
FROM   wm_ad_hoc.OWNED_ITEM_STORE_DLY temp, 
       wm_ad_hoc.OWNED_ITEM_STORE_DLY_UTIL util 
SET    temp.VENDOR_STOCK_ID = util. VENDOR_STOCK_ID, 
       temp.ON_HAND_EACH_QTY = util. ON_HAND_EACH_QTY, 
       temp.VENDOR_STOCK_ID = util.VENDOR_STOCK_ID 
WHERE  temp. VENDOR_NBR = util. VENDOR_NBR 
AND    temp.WMI_ITEM_NBR = util.WMI_ITEM_NBR 
AND    temp. store_nbr = util. store_nbr 
AND    temp.BUSINESS_DATE = util.BUSINESS_DATE

Upvotes: 2

Views: 4745

Answers (1)

Andrew
Andrew

Reputation: 8758

You need to not qualify your SET columns. So:

UPDATE temp 
FROM   wm_ad_hoc.OWNED_ITEM_STORE_DLY temp, 
       wm_ad_hoc.OWNED_ITEM_STORE_DLY_UTIL util 
SET    VENDOR_STOCK_ID = util.VENDOR_STOCK_ID, 
       ON_HAND_EACH_QTY = util.ON_HAND_EACH_QTY, 
       VENDOR_STOCK_ID = util.VENDOR_STOCK_ID
...

Upvotes: 4

Related Questions