更新换算关系

merge into ERP_DWXX A
using BC_ERP_dwXX@Ctdb B
on (A.WLDWID=B.WLDWID and A.wlxxid=B.WLXXID and A.wldwid<>'0')
when matched then
update set A.HSGX = B.HSGX ;

原文地址:https://www.cnblogs.com/eastwjn/p/9363990.html