linetech 发表于 2008-01-10 12:49

A subquery has returned not exactly one row.

执行
update mxodfport set relateddistrictcuid=(select relatedspacecuid from asite where asite.zipcode=mxodfport.siteid);

出现
A subquery has returned not exactly one row.错误。
请帮忙看一下是什么问题。谢谢！

xxyyy 发表于 2008-01-10 13:36

提示已经很明确了，你的子查询返回不只一行数据。

linetech 发表于 2008-01-10 20:03

非常感谢！
页: [1]
查看完整版本: A subquery has returned not exactly one row.