title: Firebird UPDATE a field using conditions of other table
body: <p>I have two tables in Firebird with the following fields:</p>
  
  <pre><code>TABLEA: KEY, ITEM, LAST_SALE_DATE 
  
  TABLEB: KEY, ROT
  </code></pre>
  
  <p>Both are related by the key. They refer to the same item using the key field.</p>
  
  <p>I want to update <code>TABLEB.ROT='A' where TABLEA.LAST_SALE_DATE&gt;01/01/2016</code>.</p>
  
  <p>I can't figure how to make the statement, please help.</p>