title: SQL Query - Using Order By in UNION
body: <p>How can one programmatically sort a union query when pulling data from two tables? For example,</p>
  
  <pre><code>SELECT table1.field1 FROM table1 ORDER BY table1.field1
  UNION
  SELECT table2.field1 FROM table2 ORDER BY table2.field1
  </code></pre>
  
  <p>Throws an exception</p>
  
  <p>Note: this is being attempted on MS Access Jet database engine</p>