insert into table2(field1,field2,field3,field4,field5)(select field1,field2,field3,field4,field5 from table1 where field1 not in (select field1 from table2) and field1 is not null and field'')
insert into table2(field1,field2,field3,field4,field5)(select field1,field2,field3,field4,field5 from table1 where field1 not in (select field1 from table2) and field1 is not null and field'')