title: sqlite inner join update - 3 tables
body: <p>I have 3 tables on SQLite and like to update table1 based on the values from table3.</p>
  
  <p>On MySQL:</p>
  
  <pre><code>UPDATE table1 t1 
  JOIN table2 t2 ON t2.id = t1.id_t2 
  JOIN table3 t3 ON t2.id_t3 = t3.id 
  SET t1.name = 0 WHERE t3.name = 0;
  </code></pre>
  
  <p>I know, that SQLite no support UPDATE-JOIN, but I don't know, what is good solution without JOIN?</p>