sql中update多表处理

示例：

UPDATE    A
SET A.c2 =B.c3
from A ,B
where A.c1=B.c1

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