用另一个表中的值更新表 [英] Update table with value from another table

问题描述

我尝试通过使用IP_ID通过遵循sybtax来比较2个表的方式来更新一个表中的值

I try to update value from one table with another table by use IP_ID to compare 2 table by following sybtax

UPDATE EDWID02.CUSTOMER_MOBILE t1
   SET T1.MOBILE = (
      SELECT T2.MOBILE
      FROM EDWID02.NEW_MOBILE t2
      WHERE T1.IP_ID=T2.IP_ID)

我发现的错误是DB2数据库错误：

The error I found was DB2 Database Error:

ERROR [21000] [IBM][DB2/AIX64] SQL0811N  The result of a scalar fullselect, 
SELECT INTO statement, or VALUES INTO statement is more than one row.  
SQLSTATE=21000

即使我更改=到，它也告诉我另一个错误DB2数据库错误：

even I change = to in it's told me another error DB2 Database Error:

ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token "in" was found
following "t1    SET T1.MOBILE".  Expected tokens may include:  "=".
SQLSTATE=42601

我正在DB2中进行编码。

I am coding in DB2.

推荐答案

您的误解

'UPDATE t1 SET value=onevalue'

一个值必须是单个值。您可以通过以下方式实现此目的：（从t2的t1位置选择t1.id = t2.id，仅获取第一行）

onevalue needs to be a single value. You may achieve this by (SELECT value FROM t2 WHERE t1.id = t2.id FETCH FIRST 1 ROW ONLY)

这篇关于用另一个表中的值更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！