正文Oracle 一个表的数据update到另一个表IP云V管理员/2022-06-19/2 阅读 06/19小程序:扫一扫查出行【扫一扫了解最新限行尾号】复制小程序 A表数据B表数据 现在要把B表 B_COSTS 的值update到A表 A_COSTS 字段SQL语法:update a set (a.a_costs) = (select b.b_costs from b where a.id = b.id and a.a_id = b.b_id) where exists (select 1 from b where a.id = b.id and a.a_id = b.b_id)结果: