title: How can I sync two SQLite tables using SQL?
body: <p>I have two tables that both have PhraseId as a key:</p>
  
  <pre><code> Phrase containing 
          PhraseId, name and score column
   PhraseSource containing 
          PhraseId and name column
  </code></pre>
  
  <p>The PhraseSource table is populated during an update and it may have less, the same or more rows.</p>
  
  <p>Is there a way I can </p>
  
  <ol>
  <li>Copy new rows into the Phrase table if they exist in PhraseSource but not Phrase</li>
  <li>Update rows in the Phrase table where the name is different in PhraseSource and Phrase</li>
  <li>Delete rows in the Phrase table where those rows are present in Phrase but not in Phrase source</li>
  </ol>
  
  <p>Note that I need to preserve the score data in the Phrase table.</p>