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