title: MySQL combine results from UNION of same-scheme tables
body: <p>There are two tables with the same structure: 'imsc_storage_users' &amp; 'imsc_storage_users_archive'.</p>
  
  <p>My current SELECT/UNION:</p>
  
  <pre><code>SELECT `cli`,`ts`,`questions`, `answers`,`correct`,`last`,`minutes` 
  FROM  `imsc_storage_users`
  UNION DISTINCT
  SELECT `cli`,`ts`,`questions`, `answers`,`correct`,`last`,`minutes` 
  FROM  `imsc_storage_users_archive`
  ORDER BY `correct` DESC,`minutes` ASC
  </code></pre>
  
  <p>I'm getting these results:</p>
  
  <pre><code>+--------------+---------------------+-----------+---------+---------+------+---------+
  | cli          | ts                  | questions | answers | correct | last | minutes |
  +--------------+---------------------+-----------+---------+---------+------+---------+
  | 111111111111 | 2011-12-22 11:13:57 |        30 |      29 |      14 |   30 | 1305.47 |
  | 222222222222 | 2011-12-15 13:39:16 |        26 |      24 |      13 |   24 |   15.67 |
  | 333333333333 | 2011-12-15 13:39:39 |        26 |      25 |      11 |   25 |   15.18 |
  | 444444444444 | 2011-12-15 13:39:39 |        25 |      21 |      11 |   25 |  280.53 |
  | 111111111111 | 2011-12-22 11:13:57 |        25 |      21 |      10 |   25 |  373.87 |
  | 555555555555 | 2011-12-19 15:46:15 |        11 |      10 |       5 |   10 |     3.8 |
  | 666666666666 | 2011-12-15 13:39:16 |        14 |      10 |       4 |   10 |  321.64 |
  | 777777777777 | 2011-12-19 08:34:36 |        15 |      11 |       4 |   13 |  474.66 |
  </code></pre>
  
  <p>Notice that '111111111111' appears twice?</p>
  
  <p>I want it to be combined, <strong>so in the results set I get one row of '111111111111' which combines/sums all fields; 'questions' =>> 55.... etc'</strong>.</p>
  
  <p>What would be the correct SQL?<br/>
  Performance are NOT of an issue here.</p>
  
  <p>Thank you!</p>