SQL修改多条记录SQL 多记录修改Update Table_1SetUserNameTable_2.UserNameFromTable_2,Table_1 Where Ta
SQL修改多条记录
SQL 多记录修改
Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
SQL修改多条记录
SQL 多记录修改
Update Table_1
Set
UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode