Note that the additional join in your case is added because the explicit join in your query can not be reused for fetching of the association. This is because you use a custom ON clause. Note that it would not be safe to use the data from that SQL join because if you change the collection, Hibernate might remove rows which were previously filtered out through your condition.