Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
条件:UserCode 为主键
admin2025/6/7 9:13:37【news】
简介武汉网站建设 熊掌号,百度seo公司一路火,万商云集(成都)科技股份有限公司,大连公司排名Update Table_1 Set UserNameTable_2.UserName From Table_2,Table_1 Where Table_2.UserCodeTable_1.UserCode 条件:UserCode 为主键
Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
条件:UserCode 为主键