insert into table1(aa,bb)
select aa,bb from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)
select aa,bb from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)
select *
from table2
where checksum(*) not in(select checksum(*) from table1)
select aa,bb from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)
select aa,bb from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)
select aa,bb from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)
select * from table2
where not exists(select * from table1 where table1.aa=table2.aa and table1.bb=table2.bb)