title: Oracle RIGHT OUTER JOIN not working properly?
body: <p>Ok, so lets say I have two tables: Table1[Rows: id, num, name], Table2[Rows: num, description]. I would like to query Table1 to result the id's for all rows on which Table1.num = Table2.num. So I writte:</p>
  
  <pre><code>SLECT t1.id, t1.num, t2.description
   FROM Table1 t1 RIGHT OUTER JOIN
        Table2 t2 ON (t1.num = t2.num)
  </code></pre>
  
  <p>/<em>Table2 has only one record which is as follows: Num = 123, Description = 'Abc'</em>/</p>
  
  <p>So my result should be something like this:
  1, 123, Abc
  2, 123, Abc
  5, 123, Abc</p>
  
  <p>But the result I'm getting is;
  3, 111, Null
  4, 222, Null</p>