请问一下写在查询分析器上的语句:update lzhu set zaiwang = (select zaiwang from kkkkk where kkkkk.haoma=lzhu.haoma)
出现的错误是:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated. ——www.360xianhua.com
请问是何原因?
出现的错误是:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated. ——www.360xianhua.com
请问是何原因?
from kkkkk as A
where kkkkk.haoma=lzhu.haoma
上面的值不是唯一值。