title: Merging tables from two different databases (Python)
body: <p>I have two databases <code>Database1.db</code> and <code>Database2.db</code>. The databases contain tables with <strong>matching names and matching columns</strong> (and the Primary key is the 'Date' column in both). The only difference between the two is that the entries in Database1 are from 2013 and the entries in Database2 are from 2014. I would like to merge these two databases so that all the 2013 and 2014 data ends up <strong>in one table</strong> in a third database (let's call it Database3.db). </p>
  
  <p>To be clear, here is what the databases I'm working with currently contain and what I want the third resulting database to contain: </p>
  
  <p>Database1.db:</p>
  
  <p>Table Name: GERMANY_BERLIN</p>
  
  <pre><code>Date            Morning    Day     Evening    Night
  01.01.2013      0.5        0.2      0.2       0.1
  02.01.2013      0.4        0.3      0.1       0.2
  ...
  </code></pre>
  
  <p>Database2.db:</p>
  
  <p>Table Name: GERMANY_BERLIN</p>
  
  <pre><code>Date            Morning    Day     Evening    Night
  01.01.2014      0.6        0.2      0.1       0.1
  02.01.2014      0.5        0.2      0.3       0.0
  ...
  </code></pre>
  
  <p>I would like to have create a resulting Database3 with the following data:</p>
  
  <p>Database2.db:</p>
  
  <p>Table Name: GERMANY_BERLIN</p>
  
  <pre><code>Date            Morning    Day     Evening    Night
  01.01.2013      0.5        0.2      0.2       0.1
  02.01.2013      0.4        0.3      0.1       0.2
  01.01.2014      0.6        0.2      0.1       0.1
  02.01.2014      0.5        0.2      0.3       0.0
  ...
  </code></pre>
  
  <p>I haven't been able to find anything directly helpful on this online yet (perhaps JOINS could be used somehow? bhttp://www.tutorialspoint.com/sqlite/sqlite_using_joins.htm) so any suggestions would be greatly appreciated!</p>
  
  <p>PS. SQLite has been used to create the existing databases and is the database-related Python library that I'm most familiar with</p>