Hi,

I have this sql query but i don't know how to write it in HQL...
Thanks for your help.

SELECT *
FROM
(
SELECT BOOKING_ID AS lastBOOKING_ID, max(WORKFLOW_DATE)AS lastDATE
FROM BO_WORKFLOW
WHERE WORKFLOW_STATUS = 0
GROUP BY BOOKING_ID
)
INNER JOIN BO_WORKFLOW ON (lastBOOKING_ID=BOOKING_ID) and (lastDATE=WORKFLOW_DATE)

You'll have to show your mapping and express your request in plain english too. It'll help us (and you :) )

From-clause subselects are not supported in HQL and probably will not ever be. Use createSQLQuery().