title: Combine 2 queries to get data in same row in Oracle
body: <p>I have created 2 queries result set is like below:</p>
  
  <p>Query 1:</p>
  
  <pre><code>ID Name Value Choice
  1  abc   10    x
  2  def   20    x
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre><code>ID1 Name1 Value1 Choice1
  1  eft   10    y
  2  bgf   20    y
  </code></pre>
  
  <p>I have added a full outer join and result set is like</p>
  
  <pre><code>ID   Name Value Choice ID1  Name1 Value1 Choice1
  1    abc   10    x     null null   null    null
  2    def   20    x     null null   null    null
  null null  null  null  1     eft     10    y 
  null null  null  null  2     bgf     20    y 
  </code></pre>
  
  <p>But I need like below:</p>
  
  <pre><code>ID   Name Value Choice ID1  Name1 Value1 Choice1
  1    abc   10    x     1     eft     10    y 
  2    def   20    x     2     bgf     20    y 
  </code></pre>
  
  <p>Not sure on what join or logic should I use.</p>