查询满足条件的数据到一张新表

select * INTO NEW_TABLE from TABLE;

关联更新操作

update  TABLE_A set COLUMN_A=xxx from TABLE_A  a,TABLE_B b where a.COLUMN_X=b.COLUMN_X and a.COLUMN_X =xxx and b.COLUMN_X =xxx;