开发者

SQL - Update a table using a field of another table

开发者 https://www.devze.com 2023-03-04 00:04 出处:网络
I am trying to execute the following update query: UPDATE Commodities INNER开发者_运维技巧 JOIN UniqueCountries

I am trying to execute the following update query:

UPDATE Commodities 
INNER开发者_运维技巧 JOIN UniqueCountries 
     ON Commodities.wbCode = UniqueCountries.wbCode 
SET Idenb = UniqueCountries.wbName||yr

The query is clearly wrong, as it doesnt work. How can I fix it?


The query is supposed to update column IdenB with the concatenated value of wbName and yr (wbName||yr). However, wbName is on another table called UniqueCountries, which is why I tried to perform an Inner Join.

What am I doing wrong and how can I fix it? Thank you very much.


I can't see any indication in the docs that FROM or JOIN are supported in UPDATE statements.

Maybe you could try a correlated sub query if not.

UPDATE Commodities  
SET Idenb = (SELECT UniqueCountries.wbName||yr 
             FROM UniqueCountries 
             WHERE Commodities.wbCode = UniqueCountries.wbCode)
0

精彩评论

暂无评论...
验证码 换一张
取 消