title: Sqlite select * from multiple tables
body: <p>I really need some help with sqlite.</p>
  
  <p>I have one database with two tables, lets call them table1 and table2.
  These two tables are the same basically, same column names and same amount of columns.</p>
  
  <p>First column is TEXT and the rest is double, this applies for both tables.</p>
  
  <p>I don't want to combine them into one table. If new information should arise that normally should go into table1 I want to insert it to table2. </p>
  
  <p>The problem is when I use select to search in both tables like this:</p>
  
  <pre><code>SELECT * FROM table1, table2
  </code></pre>
  
  <p>But this does not work. I just want to print those tables together.
  How do I do this?</p>