Question

oracle求助表t1(a,b),t2(a,b),怎么将表t1与t2中不同的a字段值的数据（a，b）插入t1中

是t2的不同数据插入到t1中

Answer 1

Insert into t1 (select * from t2 where a not in (select a from t1))