[newbie] Transferring data

[Peter Schmitz]

Hi,

I've got the following problem:

I've got two queries that both have (when being executed) one column, like
this:

Query1 -> Column: Articles1
Query2 -> Column: Articles2

Now, unfortunately, I cannot rename the column headings (Articles1,
Articles2) - which gives me some problems in SQL.
Basically, I need to have the result of both queries in one table AND in ONE
column, like this:

Query1: Query2: ResultTable

Articles1 Articles2
AnyColumnHeading
----------- -----------
-----------
a d a
b e b
c f c
d
e
f

Is there any SQL statement that gives me result above?

Thanks a lot
Peter

 

[Ken Snell [MVP]]

You need a Union query:

SELECT * FROM Query1
UNION ALL
SELECT * FROM Query2;