merging queries 1

[kiloslug]

I have a number of queries that have the same headings on them. I would like to merge these queries together so that all the data is in the same columns. Can this be done?

ex.

Query 1
Name Number
alan 23
fred 56

Query 2
Name Number
alan 46
fred 36

merge to
Query 3
Name Number
alan 23
alan 46
fred 56
fred 36

 

[DotNetGnat]

SELECT Name, Number FROM query1
UNION ALL
SELECT Name, Number FROM query2
UNION ALL
SELECT Name, Number FROM query3

-DNG