title: how to use "where not in" in sql ce database query?
body: <p>I'm working with SQL Server and SQL CE
  I'm trying to make a simple subquery</p>
  
  <pre><code>Select * From Item_Lots where Distribution_Code NOT IN
  (select Distribution_Code from Stock_Serials)
  </code></pre>
  
  <p>, but it doesn't work on SQL CE !!</p>
  
  <p>Any work around for this ?</p>