title: Using NHibernate to query with NOT IN in the WHERE clause
body: <p>Take this query as an example:</p>
  
  <pre><code>select * from publisher 
  where id not in (
      select publisher_id from record 
      where year = 2008 and month = 4
  )
  </code></pre>
  
  <p>Can anyone help me on how I could build and run this query using NHibernate? Assume that I have 2 classes: <code>Publisher</code> and <code>Record</code>.</p>
  
  <p>Thanks</p>