I have following SQL query. How to map this to hibernate query ? '(' seems causing issue. Is this possible with Criteria Query ?
select id from
(select prev.id from my_table prev where date = :prevDate) P
LEFT OUTER JOIN
(select curr.id from my_table curr where date = :currDate) C
ON P.id = C.id
where C.id is null