title: Update WHERE NOT EXISTS problem
body: <p>This query gives an error whenever there are more than 1 record that exists in tbl1 and not in tbl1_temp</p>
  
  <p>How can I fix this so that for every record that does not exist in tbl1_temp, update the corresponding record's status in tbl1</p>
  
  <pre><code>UPDATE tbl1 SET Status = 'Finished' 
  WHERE id = (SELECT id 
  FROM tbl1 
  WHERE NOT EXISTS (SELECT id FROM tbl1_temp 
  WHERE tbl1.id = tbl1_temp.id))
  </code></pre>