title: T-SQL: [column] not like [any value from another select]
body: <p>I have table <code>shop</code> with an <code>Email</code> column.</p>
  
  <p>Also I have another table <code>Unsubscribed</code> with a <code>EmailPattern</code> column.</p>
  
  <p>How I can select only shops with <code>Email</code> column does not match any <code>EmailPattern</code> value from <code>Unsubscribed</code> table?</p>
  
  <p>Example:</p>
  
  <p>Unsubscribed has these records:</p>
  
  <pre><code>aaa
  bbb
  ccc
  </code></pre>
  
  <p>I expect result like:</p>
  
  <pre><code>select * 
  from Shop 
  where Email not like "%aaa%" 
    and Email not like "%bbb%" 
    and Email not like "%ccc%"
  </code></pre>