UPDATE D SET  D.KHOI_ID = C.DVDM_ID
FROM dbo.PL_COSTCENTER_DT P
LEFT JOIN dbo.CM_DEPARTMENT D ON D.DEP_ID=P.DEP_ID AND D.BRANCH_ID = P.BRANCH_ID
LEFT JOIN dbo.PL_COSTCENTER C ON C.COST_ID =P.COST_ID
JOIN CM_DVDM cd ON  C.DVDM_ID =cd.DVDM_ID AND cd.IS_KHOI=1