title: Unable to delete row from table
body: <p>I have two database <code>main</code> and <code>main_2</code> and two tables <code>table1</code> in the <code>main</code> database and <code>table2</code> in the <code>main_2</code> database.</p>
  
  <p>I want to delete rows from <code>table2</code> which are not in <code>table1</code> and I am using following query:</p>
  
  <pre><code>delete from main_2.dcl.table2
  where slno not in (select slno from main.dcl.table1)
  </code></pre>
  
  <p>I am getting</p>
  
  <blockquote>
    <p>0 row(s) affected</p>
  </blockquote>
  
  <p>But actually the rows are present in <code>table2</code>, I checked manually.</p>