title: Sql server union but keep order
body: <p>Is there a way to union two tables, but keep the rows from the first table appearing first in the result set?</p>
  
  <p>For example:</p>
  
  <p>Table1</p>
  
  <pre><code>name        surname
  -------------------
  John         Doe
  Bob          Marley
  Ras          Tafari
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>name       surname
  ------------------
  Lucky      Dube
  Abby       Arnold
  </code></pre>
  
  <p>I want the result set to be:</p>
  
  <pre><code>name        surname
  -------------------
  John         Doe
  Bob          Marley 
  Ras          Tafari
  Lucky      Dube
  Abby       Arnold
  </code></pre>
  
  <p>Unfortunately, union somehow reorders the table. Is there a way around this?</p>