title: How to rearrange a result set from a UNION query?
body: <p>I have a query that seems to be alphabetizing based on the text values of the Result Set.</p>
  
  <p>My query looks like this:</p>
  
  <pre><code>SELECT 'N/A' FROM [Games] UNION SELECT [Games].[Title] FROM Games;
  </code></pre>
  
  <p>The Result Set looks like this:</p>
  
  <pre><code>Final Fantasy VII
  N / A
  The Legend of Zelda
  </code></pre>
  
  <p>I would like the Result Set to look like this:</p>
  
  <pre><code>N / A
  Final Fantasy VII
  The Legend of Zelda
  </code></pre>
  
  <p>Where Final Fantasy VII and The Legend of Zelda are actual entries in the Games table and N / A is, of course, not.</p>
  
  <p>Any help is appreciated.</p>