<p>I have a database with two tables (<code>Table1</code> and <code>Table2</code>). They both have a common column <code>[ColumnA]</code> which is an <code>nvarchar</code>. </p>

<p>How can I select this column from both tables and return it as a single column in my result set?</p>

<p>So I'm looking for something like:</p>

<pre><code>ColumnA in Table1:
a
b
c

ColumnA in Table2:
d
e
f

Result set should be:
a
b
c
d
e
f
</code></pre>

```
```
SELECT ColumnA FROM Table1 UNION Select ColumnB FROM Table2 ORDER BY 1
```
```
Also, if you know the contents of Table1 and Table2 will
NEVER
overlap, you can use UNION ALL in place of UNION instead.  Saves a little bit of resources that way.
-- Kevin Fairchild