title: How to combine results of two queries into a single dataset
body: <p>I have two queries :
  Queries Simplified excluding Joins</p>
  
  <pre><code>Query 1 : select ProductName,NumberofProducts (in inventory) from Table1.....;
  Query 2 : select ProductName, NumberofProductssold from Table2......;
  </code></pre>
  
  <p>I would like to know how I can get an output as :</p>
  
  <pre><code>ProductName NumberofProducts(in inventory)  ProductName NumberofProductsSold
  </code></pre>
  
  <p>The relationships used for getting the outputs for each query are different.
  I need the output this way for my SSRS report .</p>
  
  <p>(I tried the union statement but it doesnt work for the output I want to see. )</p>