oracle 跨表更新

update AllPunishment a set (a.CreditID)=(select b.CreditID from CorporationMainTable b  where  b.CorporationName=a.CorporationName and b.OrganizationCode=a.OrganizationCode and rownum =1) where  exists (select 1 from CorporationMainTable b where b.CreditID=a.CreditID)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/xsmhero/p/2006671.html