Insert into Zip

Select ZIP, City, County, State

From ZIP_CODE_IMPORT

Where ID Not in (

Select ID

From ZIP_CODE_IMPORT a,

Zip b

Where a.Zip = b.Zip

And a.City = b.City

And a.Country = b.Country

And a.State = b.State

)