title: How do I Combine these SQL SELECT queries into one SELECT statement
body: <p>How do I combine these two select statements into one query:</p>
  
  <pre><code>SELECT SUM( incidents )  AS fires, neighborhoods AS fire_neighborhoods
  FROM (
  SELECT * 
  FROM `fires_2009_incident_location` 
  UNION ALL SELECT * 
  FROM `fires_2008_incident_location`
  UNION ALL SELECT * 
  FROM `fires_2007_incident_location`
  UNION ALL SELECT * 
  FROM `fires_2006_incident_location`
  ) AS combo
  GROUP BY fire_neighborhoods ORDER BY fires DESC
  
  
  
  SELECT SUM( incidents )  AS adw, neighborhoods AS adw_neighborhoods
  FROM (
  SELECT * 
  FROM `adw_2009_incident_location` 
  UNION ALL SELECT * 
  FROM `adw_2008_incident_location`
  UNION ALL SELECT * 
  FROM `adw_2007_incident_location`
  UNION ALL SELECT * 
  FROM `adw_2006_incident_location`
  ) AS combo2
  GROUP BY adw_neighborhoods ORDER BY adw DESC
  </code></pre>
  
  <p>So, I'd like the query to return, something like:</p>
  
  <pre><code>fire_neighborhoods  fires  adw_neighborhoods  adw
  xyzNeighborhood     6      abcNeighborhood    22
  jklNeighborhood     3      tuvNeighborhood    40
  </code></pre>
  
  <p>I want to simply combine the results of the two queries above. The two queries are independent of each other. The results of one doesn't effect the results of the other query. I simply need a way to slam the two results together into one. </p>
  
  <p>If anyone has any advice, please let me know. </p>
  
  <p>Thank you.</p>
  
  <p>-Laxmidi</p>