title: Access SQL - UPDATE If no record exists
body: <p>I'm trying to update checkbox in record If record in table doesn't exist in another table.</p>
  
  <p>Example data:</p>
  
  <pre><code>Table1:
  111 John Davies
  222 Mike Johnson
  333 Allen Mckenzie
  
  Table2:
  000 John Jackson
  222 Laura Kent
  444 Paul Saint
  </code></pre>
  
  <p>I want to update only records, that have all fields different together, so in other words - each field doesn't exist. In my example result for this would be:</p>
  
  <pre><code>444 Paul Saint
  </code></pre>
  
  <p>I've tried with NOT IN, LEFT JOIN, INNER JOIN, but can't figure out correct clause because I need to update checkbox - so clause MUST Involve UPDATE.</p>
  
  <p>Any ideas ?</p>