這語句有錯嗎?怎麼想也搞不明白!!!請各位幫我一下(10分)

update pvalue
set value=(select rjvalue from ls3,pvalue
where pvalue.no=ls3.no and pvalue.rsno=ls3.rsno
and pvalue.mc=ls3.mc and ls3.mg=1)
提示如下錯誤:
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.
如要改正該如何改？？

是不是返回多个结果，无法对应
update pvalue a
set a.value=b.rjvalue
from ls3 b
where a.no=b.no and a.rsno=b.rsno and a.mc=.mc and b.mg=1

你的子查询语句应该只有一个返回值，而你的肯定是有多行值
好好检查一下你的子查询语句，尤其是where 后边

我也知道返回的是多個值,但是我真的不知道怎麼改好,你們能不能幫我改一下?

搞定了,謝謝