title: something like NOT LIKE (select statement from other table)
body: <p>I have 3 tables</p>
  
  <pre><code>SUFFIX_LIST(Item VARCHAR),
  PREFIX_LIST(Item VARCHAR), and
  VALID_LIST(Part1 VARCHAR, Part2 VARCHAR)
  </code></pre>
  
  <p>now i need column VALID_LIST.Part1 &amp; VALID_LIST.Part2 in way that 
  Part1 doesnt match partially from any of the Item from SUFFIX_LIST and
  Part2 doesnt match partially from any of the Item from PREFIX_LIST.</p>
  
  <p>I am using, SQLite as my local database and using c# for application development!</p>
  
  <p>Thanks in advance!</p>
  
  <h2>edit for clarification</h2>
  
  <p>VALID LIST</p>
  
  <pre><code>sample1, somedomain.com
  samplebanword, someotherdomain.com
  simplestring, someotherotherdomain.net
  morestring, my-domain.com
  </code></pre>
  
  <p>PREFIX_LIST</p>
  
  <pre><code>ban
  text
  </code></pre>
  
  <p>SUFFIX_LIST</p>
  
  <pre><code>.net
  otherother
  </code></pre>
  
  <p>now, what i want is, when the query i must get</p>
  
  <pre><code>Output
  --------
  sample1, somedomain.com
  morestring, my-domain.com
  </code></pre>