<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>

The second table cannot include the table name in the
```
ORDER BY
```
clause.
So...
```
```
SELECT table1.field1 FROM table1 ORDER BY table1.field1
UNION
SELECT table2.field1 FROM table2 ORDER BY field1
```
```
Does not throw an exception