Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
条件:UserCode 为主键
Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
条件:UserCode 为主键
转载于:https://www.cnblogs.com/zhangpengshou/archive/2009/02/27/1399906.html