title: Drools-Equivalent of the "not in" SQL
body: <p>I have two tables A and B. I want to update column A in table A if it doesn't have a match with column B in table B.</p>
  
  <p>I've written the following, but it doesn't work.</p>
  
  <pre><code>rule "Lookup"
  
  when
    B($colB: colB)
    $a : A($colB not contains colA)
  
  then 
    modify($a){
     setcolA(1000)
   }
  end
  </code></pre>
  
  <p>I've tried using accumulate as well but in vain. Any suggestions are highly appreciated.</p>
  
  <p>Equivalent in SQL is</p>
  
  <pre><code>Update colA set colA =1000 from A where colA not in (Select colB from B)
  </code></pre>