title: Oracle SQL combine output from two queries into single output
body: <p>I am not able to create tables, but I want to combine the output from two queries into a single output. What I currently have</p>
  
  <p>Output 1:</p>
  
  <pre><code>Date    Promo   Count
  1-Aug   PROMO1  8
  1-Aug   PROMO2  3
  2-Aug   PROMO1  3
  2-Aug   PROMO2  4
  </code></pre>
  
  <p>Output 2:</p>
  
  <pre><code>Date    Promo                 Count
  1-Aug   DIFFERENTKINDOFPROMO1   3
  2-Aug   DIFFERENTKINDOFPROMO1   5
  </code></pre>
  
  <p>What I'm trying to get (combine Output 1 and 2)</p>
  
  <pre><code>    Date    Promo   Count
  
      1-Aug   PROMO1  8
      1-Aug   PROMO2  3
      1-Aug   DIFFERENTKINDOFPROMO1   3
      2-Aug   PROMO1  3
      2-Aug   PROMO2  4
      2-Aug   DIFFERENTKINDOFPROMO1   5
  </code></pre>
  
  <p>As mentioned, I don't have the ability to create any tables, so I'm trying to do this on the fly so I get the final combined output. </p>