title: SQL Oracle- Combining Two Result Sets as one
body: <p>I have the following queries:</p>
  
  <pre><code>Select TRUNC(create_dtime) as Day, Count(Create_Dtime) As SinS_Tot
    From player_chkin_hist
   Where Product_Id Is Not Null
     And Trunc(Create_Dtime) &gt;= To_Date('2012-sep-01','yyyy-mon-dd')
     And Trunc(Create_Dtime) &lt; To_Date('2012-sep-19','yyyy-mon-dd')
   Group By Trunc(Create_Dtime)
   Order By 1 Asc
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Select TRUNC(Create_Dtime) As Day, Count(Create_Dtime) As Sins_Tot
    From Player_Chkin
   where Product_Id Is Not Null
     And Trunc(Create_Dtime) &gt;= To_Date('2012-sep-01','yyyy-mon-dd')
     And Trunc(Create_Dtime) &lt; To_Date('2012-sep-19','yyyy-mon-dd')
   Group By Trunc(Create_Dtime)
   Order By 1 Asc
  </code></pre>
  
  <p>Query 1 Results in:</p>
  
  <pre><code>Day          SinS_Tot
  01-Sep-12      10000
  02-Sep-12       9000
  </code></pre>
  
  <p>Query Two Results in:</p>
  
  <pre><code> Day          SinS_Tot
  03-Sep-12      11500
  04-Sep-12       9800
  </code></pre>
  
  <p>Is there an easy way to combine these two queries so that I see all data? I thought about using a join, but since the dates do not overlap, there would be nothing to set the inner join equal on.</p>