Naomi,

>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

The above doesn't work, you'll get an error. You need to specifically name the columns:

Insert into TableA (Country, State) select Country, State from TableB 

~~Bonnie