简单sql,送分交友型
表A:
studentId

表B:
studentId1,studentId2

要求A.studentId=B.studentId1时， 将 相应的B.studentId2的值设给A.studentId

实现这个功能的比较好的sql代码

[解决办法]
update A
set A.studentId=B.studentId2
from A,B
where A.studentId=B.studentId1

[解决办法]
啥叫送分交友型，笑死我了。
update a
set a.studentId1 = b.studentId2
from a
join b on A.studentId=B.studentId1
[解决办法]
update A
set A.studentId=B.studentId2
FROM A INNER JOIN B ON A.studentId=B.studentId1
[解决办法]
update a
set studentId = b.studentId2
from a,b
A.studentId=B.studentId1
[解决办法]
update A
set A.studentId=B.studentId2
from A,B
where A.studentId=B.studentId1




[解决办法]
update A
set A.studentId=B.studentId2
FROM A INNER JOIN B ON A.studentId=B.studentId1

那我等着接分好了。呵呵
[解决办法]
update a
set a.studentId1 = b.studentId2
from a
join b on A.studentId=B.studentId1