>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

You don't have to if TableB only has Country and State columns in that order as Gerard specified. Although it's a good idea to be explicit.