17,089
社区成员
发帖
与我相关
我的任务
分享
merge into tab1 a
using tab2 b
on (a.aid=b.aid and a.bid=b.bid)
when not matched then
insert values (b.aid,b.bid);
--a为中间表,b为传入数据的表
merge into tab1 a
using tab2 b
on (a.aid=b.aid and a.bid=b.bid)
when not matched then
insert values (b.aid,b.bid);