示例：
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
本文转自 netcorner 博客园博客，原文链接：http://www.cnblogs.com/netcorner/archive/2013/02/16/2913445.html ，如需转载请自行联系原作者
