我正在使用 H2 数据库并想要移动一些数据。为此,我创建了以下查询:
UPDATE CUSTOMER
SET EMAIL = SELECT service.EMAIL
FROM CUSTOMER_SERVICE AS service
INNER JOIN CUSTOMER AS customer ON service.ID = customer.CUSTOMER_SERVICE_ID;
当我现在在 H2 控制台中执行它时,出现以下错误:
Scalar subquery contains more than one row; SQL statement:
UPDATE CUSTOMER
SET EMAIL = SELECT service.EMAIL
FROM CUSTOMER_SERVICE AS service
INNER JOIN CUSTOMER AS customer ON service.ID = customer.CUSTOMER_SERVICE_ID [90053-192] 90053/90053 (Hilfe)
这个错误告诉我什么?
EDIT
我想通过我的查询实现什么:
其实每一个CUSTOMER
has a CUSTOMER_SERVICE
。我只是想移动COLUMN EMAIL
from CUSTOMER_SERVICE
to the CUSTOMER
桌子。为此,我已经向用户添加了电子邮件列。我希望能够通过我的查询来做到这一点,但显然不能。
您的选择查询返回不止一行。如果您不想这样做,那么您需要执行诸如聚合或 LIMIT 1 或类似操作之类的操作。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)