Append Results from two queries and output as a single table.
Posted
by
tHeSiD
on Stack Overflow
See other posts from Stack Overflow
or by tHeSiD
Published on 2011-01-06T19:42:53Z
Indexed on
2011/01/06
19:53 UTC
Read the original article
Hit count: 196
I have two queries that I have to run, I cannon join them But their resultant tables have the same structrure.
For example I have
select * from products where producttype=magazine
select * from products where producttype = book
I have to combine the result of these two queries, and then output it as one single result. I have to do this inside a stored procedure.
PS These are just examples I provided, i have a complex table structure. The main thing is I cannot join them.
© Stack Overflow or respective owner