title: CAML "NOT IN" query
body: <p>Is there a way to do something like "NOT IN" behavior in SharePoint 2010? I can easily implement IN behavior like that:</p>
  
  <pre><code>&lt;Where&gt;
     &lt;In&gt;
        &lt;FieldRef Name="ID"/&gt;
        &lt;Values&gt;
           &lt;Value Type="Counter"&gt;1&lt;/Value&gt;
           &lt;Value Type="Counter"&gt;2&lt;/Value&gt;
           &lt;Value Type="Counter"&gt;3&lt;/Value&gt;
           &lt;Value Type="Counter"&gt;4&lt;/Value&gt;
           &lt;Value Type="Counter"&gt;5&lt;/Value&gt;
        &lt;/Values&gt;
     &lt;/In&gt;
  &lt;/Where&gt;
  </code></pre>
  
  <p>But is there a way to select all the values that DOES NOT IN Values enumeration?</p>
  
  <p>Here is the USE CASE: I have a Lookup field with AllowMultipleValues = true, and I need to get all items from LookupList, which are not included into Lookup field</p>
  
  <p>Thanks in advance!</p>