UPDATE_CHUC_DANH.txt
| 1 |
UPDATE A SET A.POS_CODE = B.POS_CODE, A.POS_NAME = B.POS_NAME |
|---|---|
| 2 |
FROM CM_EMPLOYEE_LOG A |
| 3 |
LEFT JOIN CM_DEPARTMENT E ON A.DEP_CODE = E.DEP_CODE |
| 4 |
INNER JOIN CM_EMPLOYEE B ON A.EMP_CODE = B.EMP_CODE |
| 5 |
LEFT JOIN CM_BRANCH C ON B.BRANCH_ID = C.BRANCH_ID |
| 6 |
LEFT JOIN CM_DEPARTMENT D ON B.DEP_ID = D.DEP_ID |