title: ORACLE SUBQUERY NOT WORKING IN (IN CONDITION)
body: <p>I need help </p>
  
  <p>i have records 123,456,789 in rows when i am execute like</p>
  
  <p>this one is working  </p>
  
  <pre><code>select * from table1 where num1 in('123','456')
  </code></pre>
  
  <p>but when i am execute </p>
  
  <pre><code>select * from table1 where num1 in(select value from table2)
  </code></pre>
  
  <p>no resultset found - why? </p>