HQL Hibernate INNER JOIN SUBQuery

[vlad]

For derived table queries, you only option is native SQL. For other simpler queries, you can use JPQL or Criteria API.