title: Updating table based on zip code table
body: <p>I am looking for a way to update a table containing <code>city, state, zip, and county</code> by using a different table containing all the necessary information.  </p>
  
  <p>To put it simply, I have a table (let's call it <code>Table1</code>) that lists all the <code>cities, states, and counties</code> by <code>zip code</code> (or whatever order you want to put those in).  I want to update a different table (call it <code>Table2</code>), specifically <code>city, state, and county</code>, using the <code>zip code</code> from Table1.</p>
  
  <p>EDIT: MS SQL Server</p>