SQL - 使用另一个表的字段更新一个表

发布于 2024-11-05 15:42:52 字数 445 浏览 0 评论 0原文

我正在尝试执行以下更新查询：

UPDATE Commodities 
INNER JOIN UniqueCountries 
     ON Commodities.wbCode = UniqueCountries.wbCode 
SET Idenb = UniqueCountries.wbName||yr

该查询显然是错误的，因为它不起作用。我该如何修复它？

该查询应该使用 wbName 和 yr 的串联值更新列 IdenB (wbName||yr) 。但是，wbName 位于另一个名为 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.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

寻找一个思念的角度 2024-11-12 15:42:52

我在文档中看不到任何指示 FROM 或 < UPDATE 语句支持 code>JOIN。

如果没有，也许您可以尝试相关子查询。

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

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 原文

~没有更多了~