title: How to merge(columns) outputs of two SELECT statements in oracle sql?
body: <p>I have two Select queries. </p>
  
  <p>The first Select query gives the output which has two columns viz.</p>
  
  <pre><code>A   B
  ------
  1   2    
  3   4    
  5   6    
  7   8
  </code></pre>
  
  <p>The second Select query given the output which as two columns viz Column B and Column C. All the values in Column B of this select statement matches the values of Column B of the first Select statement.i.e</p>
  
  <pre><code>B   C
  ------
  2   25    
  4   50    
  6   30    
  8   50
  </code></pre>
  
  <p>Now, I need to merge the outputs of the above two Select queries. i.e</p>
  
  <pre><code>A   B   C
  ----------
  1   2   25    
  3   4   50    
  5   6   30    
  7   8   50
  </code></pre>
  
  <p>I cannot use views to store the output of the two select queries. I need to use the Column B in both select queries to merge. However, I am not able to figure out how to go about it.</p>