>>Insert into TableA (Country, State) select * from TableB >>where not exists >> (select 1 from TableA where TableA.State = TableB.State and TableA.City = TableB.City) -- if you only want to append new (not existing) records>
>Insert into TableA (Country, State) select Country, State from TableB >>