title: Excel and SQL, order by help
body: <p>Im stuck in Excel 2007, running a query, it worked until I wanted to add a 2nd row containing "field 2".</p>
  
  <pre><code>Select "Site Updates"."Posted By", "Site Uploaded"."Site Upload Date"
  From site_info.dbo."Site Updates"
  Where ("Site Updates"."Posted By") AND "Site Uploaded"."Site Upload Date"&gt;={ts '2010-05-01 00:00:00'}), ("Site Location"='Chicago')
  Union all
  Select "Site Updates"."Posted By", "Site Uploaded"."Site Upload Date"
  From site_info.dbo."Site Updates"
  Where ("Site Updates"."Posted By") AND "Site Uploaded"."Site Upload Date"&gt;={ts '2010-05-01 00:00:00'}), ("Site Location"='Denver')
  Order By "Site Location" ASC;
  </code></pre>
  
  <p>Basically I want 2 different cells for the locations, example</p>
  
  <pre><code>name - Chicago - denver
  user1 - 100 - 20
  user2 - 34 - 1002
  </code></pre>
  
  <p>Right now for some odd reason, its combining it like:</p>
  
  <pre><code>name - chicago
  user1 - 120
  user2 - 1036
  </code></pre>
  
  <p>Please note updating to 2010 beta is not a viable option for me at this point. Any and all input that will help me is greatly apprecaited. I have read over <a href="http://www.techonthenet.com/sql/order_by.php" rel="nofollow noreferrer">http://www.techonthenet.com/sql/order_by.php</a> however its not gotten me very far in this question. If you have another SQL resource you recomend for people trying to get their feet wet, I'd greatly apprecaite it.</p>
  
  <p>If it helps all the info is on the same table.</p>