title: LIKE using subquery returning multiple rows
body: <p>There 2 tables emailinfo(id,email) and keywordinfo(id,keyword).
  emailinfo contains 80,000 rows and keywordinfo contains 2000 rows.</p>
  
  <p>I want emails from emailinfo table which does not contains keywords from keywordinfo table.</p>
  
  <p>I want not like condition on multiple rows</p>
  
  <p>I have kept all keywords in keywordinfo table</p>
  
  <p>Now I have to fetch all the emails from emailinfo table which not containing any keywords from keywordinfo table.</p>
  
  <p>I want query like following,</p>
  
  <pre><code>select email 
  from emailinfo 
  where email not like % (select keyword from keywordinfo)
  </code></pre>
  
  <p>I have tried following query</p>
  
  <pre><code>SELECT email 
  FROM   emailinfo
         join keywordinfo on email  like '%' + keyword +'%'**
  </code></pre>
  
  <p>but its not giving me proper results and is very slow.</p>