title: Opposite Of An Inner Join Query
body: <p>can someone help me write sql for a scernerio like this:</p>
  
  <pre><code>Table 1
  
  2 columns: ID, Name
  
  Table 2
  
  2 columns: ID, Name
  </code></pre>
  
  <p>I want a query to show names from Table 1 that are not in table 2. So filter out all the names in table 1 that are in table 2 is the result query. Use ID for the filtering not name. </p>
  
  <p>This will help me in what I am trying to do. Thanks in advance</p>