Código SQL [-]Select Z1.Zip, Z1.State, Z1.City From zip1 as Z1 Where z1.Zip no in(Select z2.Zip From zip2 as Z2) And Z1.State not in(Select z3.State from Zip2 as Z3) And Z1.City not in(Select z4.City from Zip2 as Z4)
Select Z1.Zip, Z1.State, Z1.City From zip1 as Z1 Where z1.Zip no in(Select z2.Zip From zip2 as Z2) And Z1.State not in(Select z3.State from Zip2 as Z3) And Z1.City not in(Select z4.City from Zip2 as Z4)