title: Append Results from two queries and output as a single table
body: <p>I have two queries that I have to run, I cannon join them But their resultant tables have the same structrure. </p>
  
  <p>For example I have </p>
  
  <pre><code>select * from products where producttype=magazine
  
  select * from products where producttype = book
  </code></pre>
  
  <p>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. </p>
  
  <p>PS These are just examples I provided, i have a complex table structure. The main thing is I cannot join them.</p>