title: HQL Error : with-clause referenced two different from-clause elements
body: <p>I am trying to run this query which will give me the count
  but it does seem to work</p>
  
  <pre><code>def query  = "select count(A.id) from Artifact A "+
               "LEFT JOIN A.classification C on (A.id=C.artifactId) "+
               "where C.id IS NULL";
  def tc = Artifact.executeQuery(query);
  </code></pre>