title: combine two select statement in two column?
body: <p>i Have two select statement </p>
  
  <p>1</p>
  
  <pre><code>select Start_Date
      from table1  where Start_Date not in (
      select End_Date
      from table1)
  </code></pre>
  
  <p>2</p>
  
  <pre><code> select End_Date from table1
      where End_Date not in (
          select Start_Date
              from table1
          )
  </code></pre>
  
  <p>i want to combine two select statement in different column when i use union all it give me one column with the result of two queries i want each query result in different column but when i use inner join like that </p>
  
  <pre><code>select a.End_Date , b.Start_Date from
  ( select End_Date from table1
  where End_Date not in (
  select Start_Date
  from table1
  ) ) a
  
  join
  
  (select Start_Date
  from table1 where Start_Date not in (
  select End_Date
  from table1)
  ) b
  on 1=1
  </code></pre>
  
  <p>it giving me result every record is repeating four times help me what i do next ??</p>