title: Search Row not exist in another table
body: <p>Can anyone help me to write the query for below condition.</p>
  
  <p>Table 1 </p>
  
  <pre><code>        ID    Key
          1      A
          2      A
          4      C
          5      D
          6      A
  </code></pre>
  
  <p>Table 2 </p>
  
  <pre><code>        ID     Key
           2      B
           3      B
           5      D
           6      A
  </code></pre>
  
  <p>These are the two tables</p>
  
  <p>I want a query in which the ID, which is not exist in <code>Table1</code> corresponding to <code>Table2</code>, where deleted from table. </p>
  
  <p>Example: <code>ID = 1</code> row was completely deleted from <code>Table1</code>, and in which key are not match were also deleted </p>
  
  <p>Example: <code>ID = 2</code>, exists in both tables but key are not same so the complete row also delete from <code>Table1</code> not in <code>Table2</code>, I need a single query which is applicable to both condition </p>
  
  <p>Thanks in advance</p>