title: HQL: Is it possible to perform an INNER JOIN on a subquery?
body: <p><img src="https://i.stack.imgur.com/kvCBj.png" alt="Diagram"></p>
  
  <p>The diagram above is a simplified version of the database structure that I use to log item locations through time. I wrote the following SQL query which returns the current item inventory of each location:</p>
  
  <pre><code>select * 
  from ItemLocationLog l
  inner join 
  (select g.idItemLocationLog, max(g.dateTime) as latest
  from ItemLocationLog g
  group by g.idItem)
  as i 
  on l.idItem = i.idItem and l.dateTime = i.latest
  </code></pre>
  
  <p>The problem I'm having is that I want to convert that to HQL, but I haven't found the syntax to perform an INNER JOIN on a subquery, and it seems like this is not supported. Is there a way to convert the above to HQL (or a Criteria) or will I have to use a standard SQL query in this case? Thanks.</p>