title: SQL query to fetch the data from two tables with "not in" condition
body: <p>I have 2 tables, Table1 and Table2, where 2 columns in both tables are same</p>
  
  <p>update:type of Table1.col1 same as Table2.col1 and Table1.col2 same as  Table2.col2</p>
  
  <p>Trying to fetch the data where table1.col1 not in table2.col1 and table1.col2 not in table2.col2, and this is my query.</p>
  
  <pre><code>select * from Table1 
      where Table1.col1 not in (select Table2.col1 from Table2)
        and Table1.col2 not in (select Table2.col2 from Table2)
  </code></pre>
  
  <p>would like to know any better way or is this correct ?</p>