title: How to copy data from one table to another (where both have other fields too that are not in common)?
body: <p>I have 2 tables <code>Source</code> and <code>Destination</code> that have the same fields. <code>ID</code> and <code>COUNTRY</code>, though they both have other fields too that are not in common.</p>
  <p>I need to copy the <code>Source.Country</code> value to the <code>Destination.Country</code> where the join is on <code>ID</code>. I can't make SQLite do this. In SQL Server this is a super simple task.</p>