mysql update inner join

select u.OALoginName,h.OALoginName from MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
where u.OALoginName<>h.OALoginName
 
#mysql
update MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
set u.OALoginName=h.OALoginName
where u.OALoginName<>h.OALoginName
 
#sqlserver
update u set u.OALoginName=h.OALoginName from MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
where u.OALoginName<>h.OALoginName