title: Using union and count(*) together in SQL query
body: <p>I have a SQL query, looks something like this:</p>
  
  <pre><code>select name, count (*) from Results group by name order by name
  </code></pre>
  
  <p>and another, identical which loads from a archive results table, but the fields are the same.</p>
  
  <pre><code>select name, count (*) from Archive_Results group by name order by name
  </code></pre>
  
  <p>How would I combine the two in just one query? (So the group by would still function correctly). I tried with union all, however it won't work. What am I missing?</p>