title: HQL, left join on the same table
body: <p>I search a way to do a left join with the same table with hql.</p>
  
  <p>It's my query</p>
  
  <pre><code>  FROM Tvshow e
    LEFT JOIN Tvshow e1 ON e1.num = e.num
   WHERE e1.code = '024'
     AND e.code is not null
     AND e.code != '024'
  </code></pre>
  
  <p>Hibernate don't seem to like on operator.</p>