title: How to return values that are NOT in a list, compared to other values
body: <p>I'm in a production environment, trying to find a list of invoices that do not contain a specific item.</p>
  
  <p>Example:</p>
  
  <p>Invoice |  Item  </p>
  
  <pre><code>    1 | Item A 
      1 | Item B 
        |        
      2 | Item A 
      2 | Item C 
      2 | Item D 
        |        
      3 | Item B 
      3 | Item D 
        |        
      4 | Item A 
      4 | Item C 
      4 | Item F 
  </code></pre>
  
  <p>I'm looking for a query that will return all invoice numbers that do not contain Item B. </p>
  
  <p>I could use NOT IN query, but I feel like that would return invoice numbers that do have Item B associated, but not in that row.</p>
  
  <p>Any help is appreciated!</p>
  
  <p>For the example, I expect the result to return Invoice numbers 2 and 4.</p>