title: Update with Join in SQLite
body: <p>I have 2 tables and like to update one of them with the values from the other.</p>
  
  <pre><code>software
  ---------
  id ,
  purchprice
  
  softwarecost
  ------------
  id ,
  purchprice
  </code></pre>
  
  <p>I've tried these queries but, SQLite doesn't support JOINS with UPDATE.anybody out there who can come up with  a query for this.thanks for your help.</p>
  
  <pre><code>UPDATE software 
  SET software.purchprice=softwarecost.purchprice 
  WHERE software.id=softwarecost.id
  
  UPDATE software 
  INNER JOIN softwarecost on software.id=softwarecost.id 
  SET software.purchprice=softwarecost.purchprice 
  </code></pre>