如何解决错误'SUBQUERY CAN RETURN SINGLE VALUE' [英] How to solve the error 'SUBQUERY CAN RETURN SINGLE VALUE'

问题描述

我正在更新：

I am updating:

UPDATE table1 A SET (A.COLUMN_NAME) = (SELECT 1 FROM table2 WHERE A.COLUMN <> B.COLUMN)

但它会抛出错误

But it throws an error

SUBQUERY CAN RETURN SINGLE VALUE

请建议如何更新。

Please suggest how to update.

推荐答案

按照建议，子查询

SELECT 1 FROM table2 WHERE A.COLUMN <> B.COLUMN

，可能会返回超过1行。因此，存在多于一行的A.COLUMN<> B.COLUMN。



如果你想要返回一个值，请更改子查询。



如果可能的话，尝试单独运行子查询以查看它返回的内容。

, is probably returning more than 1 row. So, there is more than 1 row where A.COLUMN <> B.COLUMN.

If you want a single value returned, change the subquery.

If possible, try to run the subquery by itself to see what it is returning.

这篇关于如何解决错误'SUBQUERY CAN RETURN SINGLE VALUE'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！