UPDATE A SET A.POS_CODE = B.POS_CODE, A.POS_NAME = B.POS_NAME
FROM CM_EMPLOYEE_LOG A
LEFT JOIN CM_DEPARTMENT E ON A.DEP_CODE = E.DEP_CODE
INNER JOIN CM_EMPLOYEE B ON A.EMP_CODE = B.EMP_CODE
LEFT JOIN CM_BRANCH C ON B.BRANCH_ID = C.BRANCH_ID
LEFT JOIN CM_DEPARTMENT D ON B.DEP_ID = D.DEP_ID