merge into a tab1
using (select * from b)tab2
on tab1.<唯一约束>=tab2.<唯一约束>
when not matched then
insert (tab1.c1,tab1,c2,…) values (tab2.c1,tab2.c2,…)