UPDATE E SET E.BRANCH_CODE = '0500', E.DEP_CODE = D.DEP_CODE
FROM TL_USER A
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId
LEFT JOIN AbpRoles C ON B.RoleId = C.Id
LEFT JOIN CM_DEPARTMENT D ON A.DEP_ID = D.DEP_ID
LEFT JOIN CM_EMPLOYEE_LOG E ON A.TLNANME = E.USER_DOMAIN
WHERE C.DisplayName = 'DVCM'