title: How to combine multiple SELECT statements into a single query & get a single result output
body: <p>I have multiple SELECT queries which is ran against different tables.
  The output of all the queries have the same number of rows (every query when ran individually will have the same number of rows). Is there a way I can combine the output of all these queries into a single result? (Keep out from first query and add the output of next query as a column to the output of the next query). I dont want to save these tables into database as I am just doing some validation testing.</p>
  <p>Example:</p>
  <pre><code>SELECT AAA,BBB,CCC FROM Table1 
  
  SELECT Table2.DDD, Table1.AAA
  FROM Table2
  INNER JOIN Table1
  ON Table1.AAA = Table2.AAA
  </code></pre>
  <p>I tried writing combining the query as</p>
  <pre><code>SELECT Table1.AAA,Table1.BBB,Table1.CCC,T1.DDD
  FROM Table1, 
  (SELECT Table2.DDD, Table1.AAA
  FROM Table2 
  INNER JOIN Table1
  ON Table1.AAA = Table2.AAA)T1
  </code></pre>
  <p>I tried doing the above combined query, but instead of getting 11 rows as output (both queries above had result of 11 rows), I am getting 35 rows as output.</p>
  <p>Hope the question made sense!</p>