用一句sql能update吗？

[szsusuia]

(2001-11-08 16:40:28) 朱朱
show128,show128tmp结构同。
s1 varchar(6),s2 varchar(8),s3 decimal(8,3)
按show128tmp修改show128

用一句sql能update吗？

[icevi]

不知道你想UPDATE什么？详细点。应该可以的。

[9Thoughts]

update show128 set explist = (select explist from show128tmp where (唯一条件))

[szsusuia]

不好意思，没写清楚，别人问的问题，我觉得不行：

(2001-11-08 16:40:28) 朱朱
show128,show128tmp结构同。
s1 varchar(6),s2 varchar(8),s3 decimal(8,3)
按show128tmp修改show128

update show128 set s2=show128tmp.s2,s3=show128tmp.s3 where s1=show128tmp.s1

该语句对吗？

[昵称被占用了]

不对,改为
update show128 set s2=show128tmp.s2,s3=show128tmp.s3
from show128,show128tmp
where show128.s1=show128tmp.s1

[KingSunSha]

update show128 x
set (s2,s3) = (select s2,s3 from show128tmp y
where y.s1=x.s1);

[icevi]

update show128 set s2=show128tmp.s2,s3=show128tmp.s3 where s1=show128tmp.s1

UPDATE show128
SET s2=show128tmp.s2,s3=show128tmp.s3
FROM show128 INNER JOIN show128temp ON show128.s1=show128tmp.s1