// Insert info from one table to another and not creating dupes
insert into "ACCOUNT" select * from 2account where not exists(select file_code from account where account.file_code = 2account.file_code);
Insert into "Contacts" select * from 2contacts;
Insert into "Chg_Log" select * from 2Chg_Log;
Insert into "DailyFB" select * from 2DailyFB;
Insert into "DailyRM" select * from 2DailyRM;
Insert into "FBCateg" select * from 2FBCateg;
Insert into "FBItems" select * from 2FBItems;
Insert into "Groups" select * from 2Groups;
Insert into "Holdspac" select * from 2Holdspac;
Insert into "Hotels2" select * from 2Hotels2;
Insert into "Leads" select * from 2Leads;
Insert into "Lostbus" select * from 2Lostbus;
Insert into "Meetroom" select * from 2Meetroom;
Insert into "MenuItem" select * from 2MenuItem;
Insert into "Mergdocu" select * from 2Mergdocu;
Insert into "PaceRms" select * from 2PaceRms;
Insert into "PaceFB" select * from 2PaceFB2;
Insert into "Payments" select * from 2Payments;
Insert into "SaleCall" select * from 2SaleCall;
Insert into "Sales" select * from 2Sales;
Insert into "Sgbud" select * from 2Sgbud;
Insert into "Traces" select * from 2Traces where Status = 'O';