I have two different database one is call gmg_order_entry and the other is call gmg_claims both of them have two tables with the same name call zipcodes. However, the gmg_order_entry database zipcodes table is populated and I would like to copy those data to
the gmg_claims table call zipcodes which have the same schema as the gmg_order_entry zipcode tables. I am using Microsoft SQL Server 2000. Please advice how I may accomplished this.