update
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
delete
select * from MDMR_DimensionDept dd
inner join MDM_Dept d on dd.DeptId=d.DeptId
where dd.DimensionManageId='A88427B0-5207-4F70-A310-55D2EDB60747'
and d.DeptId='4F4E2BE3-F42A-4B34-97A4-4E7511AB6087'
#sqlserver、mysql
delete dd from MDMR_DimensionDept dd
inner join MDM_Dept d on dd.DeptId=d.DeptId
where dd.DimensionManageId='A88427B0-5207-4F70-A310-55D2EDB60747'
and d.DeptId='0574C19B-DAFC-46C4-874F-29B368AACFF4'