title: Sql Query Select From an update, records, that were not updated
body: <p>I'm using Sql server 2012</p>
  
  <p>Just curious if there is a way to do such a thing...</p>
  
  <p>My update query looks like</p>
  
  <pre><code>UPDATE a 
  SET a.TowerNumber=b.SiteNumber
  FROM tower a 
  INNER JOIN sites  b 
  ON a.sitenumber = b.sitenumber
  </code></pre>
  
  <p>what i would like to do after the ON line is something like</p>
  
  <pre><code>EDIT **select records that did not match the ON statement**
  </code></pre>
  
  <p>thanks in advance</p>