Hi,

I want to use hibernateTemplate.Find(query, paramValues) to execute such query

select A.*
from PersonModel A
inner join
( select row_number() over(order by B.SIZE) lp, B.PERSONID p from CarModel B
) window
on window.p = A.ID
and window.lp between 34 and 55
order by window.lp

How to create HQL QUERY if there is no inner join "ON" in HQL language - the relations have to be defined in hbms so only iner join on object is permitted...
On the other hand the "window" is my virtual object so I cant delete the
on window.p = A.ID part .. ???

I would like to use HQL so how to write the above query...

I need to have ORDERED results with specific rownum