title: Setting a column equal to a value when an ID does not exist in the other table SQL Server
body: <p>*****Added Clarification*****
  I have two tables: Lets say I have one that is called "V" that is in my sql database and has a column as "Active" and another table called "S" which has matching columns to V except for the "Active" column. V has more records because it has archived records as well (hence the reason for an active/unactive column). They join on an "ID" field. I need a statement that will change the active column in "V" to 0 from 1 if its ID does not exist in "S"</p>
  
  <hr>
  
  <p>Say I have two tables in a SQL Server database that I am checking against each other to ensure they match. One table has an outside data connection that gets refreshed daily. </p>
  
  <p>I am joining them on an <code>ID</code> column, but if the existing table in the database (i.e the one not getting refreshed) has an <code>ID</code> that does not exist in the refreshed table, I would like to make set the column <code>Active</code> to <code>1</code>.</p>