Merging two columns into a single list

[donjohnson]

Hello!
Here is another question that should be easy, but has me stumped.

I have a table with Name1 and Name2 columns (among others).

I would like a distinct list of all the entries in Name1 and Name 2 as a single list.

For example, if I have

Name1 Name 2
Bob Bill
Joe Larry
Don Curly
Joe Moe
Don Bob
Bob Joe

I want a single sorted list:
Bill
Bob
Curly
Don
Joe
Larry
Moe

How can I do this simply?

Thanks!
Don

 

[SQLSister]

Try a union query

Questions about posting. See faq183-874

 

[donjohnson]

Boy, do I feel stupid!

I tried a union at one time, but did it in the SQL pane of Enterprise Manager's tables function, rather than in the SQL Query Analyzer. Once I moved there, the union worked fine.

Thanks for your help - now on to some other recordset problems I have with email!

Don