UPDATE    A
SET A.c2 =B.c3
from A inner join B on A.c1=B.c1

home88一必发,多表from子句前面

相关文章