按条件更新表记录

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: 不好意思,刚没看清,你的也是对的. 赞!又会了一种方法.