title: NOT IN Clause in HQL
body: <p>How to write this query in HQL:</p>
  
  <pre><code>select * from Employee where Emp_Code 
  NOT IN (select Emp_Code from EmployeeAllocation);
  </code></pre>
  
  <p>I was unable to find any solution for this on google.
  I dont know how to write NOT IN clause in HQL
  The result should must be fetched to a List. Like this:</p>
  
  <pre><code>List&lt;String&gt; lst = query.list();
  </code></pre>