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

Filed under:
|
|

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

Related posts about sql

Related posts about sql-server