Oracle中的UPDATE FROM使用方法
Oracle中的UPDATE FROM使用方法update BO_CW_FPUBLIC a set (a.item,a.itemcode,a.smoney)=(select b.item,b.itemcode,b.zhj from BO_CW_FPUBLIC_M b wherea.bindid=b.bindid and b.fbillno like '%CLFY%')WHERE EXISTS (SELECT b.item FROM BO_CW_FPUBLIC_M bWHERE a.bindid = b.bindid and b.fbillno like '%CLFY%')