update xgs_register t
set t.emailpassowrd = (select a.email_password
from XGS_CHANGE_EMAIL a
where a.email = t.email)
where t.id >= 16000
这个他报单行子查询返回多于一行
有怎么解决它
...全文
864打赏收藏
update??
update xgs_register t set t.emailpassowrd = (select a.email_password from XGS_CHANGE_EMAIL a where a.email = t.email) where t.id >= 16000 这个他报单行子查询返回多于一行 有怎么解决它
[Quote=引用楼主 fuyou001 的回复:]
update xgs_register t
set t.emailpassowrd = (select a.email_password
from XGS_CHANGE_EMAIL a
where a.email = t.email)
where t.id >= 16000
update xgs_register t
set t.emailpassowrd = (select a.email_password
from XGS_CHANGE_EMAIL a
where a.email = t.email where rownum = 1)
where t.id >= 16000