例子,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)