1、merge into A a useing B b on(a.id=b.id) when matched when update set a.ad_id=b.ad_id
where ...(限制条件);
2、select id into b from a;
1、merge into A a useing B b on(a.id=b.id) when matched when update set a.ad_id=b.ad_id
where ...(限制条件);
2、select id into b from a;