Project

General

Profile

Download (263 Bytes)

update KHOI_ID DEP.txt

Luc Tran Van, 11/11/2022 10:15 AM

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