title: SQLite date sorting problem
body: <p>I am having 2 tables:</p>
  
  <p><strong>Table1</strong>: ID,Type,form_date</p>
  
  <p><strong>Table2</strong>: ID, Type, form_date</p>
  
  <p>Now, i want to fetch uniq date list (type wise) from both the tables and
  stores into the third table. How do i do such?</p>
  
  <p>Date example:</p>
  
  <p>Table-1:</p>
  
  <pre><code>Type    form_date
  1       20/12/2010
  1       25/04/2010
  2       05/11/2010
  </code></pre>
  
  <p>Table-2:</p>
  
  <pre><code>Type form_date
  1    20/12/2010
  2    25/04/2010
  2    05/11/2010
  </code></pre>
  
  <p>I want to have output as below:</p>
  
  <p><strong><code>Table-3 or Output</code></strong></p>
  
  <pre><code>Type form_date
  1    20/12/2010
  1    25/04/2010
  2    25/04/2010
  2    05/11/2010
  </code></pre>
  
  <p>Please suggest me a possible solution.
  Thanx</p>
  
  <h2>Update:</h2>
  
  <p>Thanx a lot <strong><code>dan04</code></strong>.
  From @dan04 answer, i am having success to store Type, form_date from both the tables.</p>
  
  <p>But when i try to execute below query to get only form_date values then it is giving me an error:</p>
  
  <pre><code>SELECT form_date FROM Table1
  UNION SELECT form_date FROM Table2
  </code></pre>
  
  <p>please suggest me how do i have only form_date from both the tables?</p>