I have 2 tables. The first table (table1) is a list of zip codes and a distributor ID for each. The second table (table2) has a smaller list of zip codes. I need to change all of the distributor IDs in table1 to another ID number ONLY IF the zip code exists in the second table.
Then I need to do a query and find all of the zip codes in the table1 where, for example, distribID = 7 currently and change it to another number ONLY IF the zip code does NOT exist in table2.
I've attempted a search for this on Google and in this site with Google but I must be guessing the wrong wording.
Thank you for your time in reading this post. Any help/guidance would be appreciated.
bob
Then I need to do a query and find all of the zip codes in the table1 where, for example, distribID = 7 currently and change it to another number ONLY IF the zip code does NOT exist in table2.
I've attempted a search for this on Google and in this site with Google but I must be guessing the wrong wording.
Thank you for your time in reading this post. Any help/guidance would be appreciated.
bob