SQL 根据一个表更新另一个表的字段

 

UPDATE a SET a.CHARGE_CODE=b.CHARGE_CODE FROM [172.16.59.3].COMM.COMM.CHARGE_PRICE a,COMM.COMM.CHARGE_PRICE b WHERE a.charge_ID=b.CHARGE_ID AND b.CHARGE_ID IN (SELECT CHARGE_ID FROM [172.16.59.3].COMM.COMM.CHARGE_PRICE WHERE EXE_DEPT_ID=23)