UPDATE A.sid = (select B.id from B where A.id=B.id )
where exists(select 1 from B where A.id=B.id );
oracle数据库修改表中某字段的值等于另另外表中字段的值
最新推荐文章于 2024-07-18 17:41:34 发布
UPDATE A.sid = (select B.id from B where A.id=B.id )
where exists(select 1 from B where A.id=B.id );