写在查询分析器上的语句: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.
请问是何原因?
那1对多的该怎么写呢?重点: 那如何删除一个表中的重复记录呢?