按条件更新表记录

Question

大概是这个意思. 两个表A,B:  表A(c1,c2,c3),表B(c1,c2,c3) 要求. update  set A.c3 = B.c3 where A.c1 = B.c1 and A.c2 = B.c2 在线等.谢谢...

Answer 1

update A

set A.c3 = B.c3

from A,B

where A.c1 = B.c1 and A.c2 = B.c2

Answer 2

update A
set A.c3 = B.c3
from A
inner join B on A.c1 = B.c1 and A.c2 = B.c2

Answer 3

谢谢.

from 要写两个表的名.

Answer 4

@leungcnblogs: 我用的是inner join

Answer 5

@dudu: 不好意思,刚没看清,你的也是对的. 赞!又会了一种方法.