Could somone help me translate this SQL into HQL.Your help is highly appreciated

[code]
SELECT
name,
MAX(isinuse) AS isinuse
FROM
(
SELECT
c.DISPLAY_TEXT AS name,
MAX(DECODE(r.FK_COMPANY, s.FK_COMPANY, 1, 0)) isinuse
FROM
SOURCEREQUIREMENT sr,
SUBSCRIPTION s,
COMPANY c,
ROLE r
WHERE s.FK_SRCREQ = sr.PK_SRCREQ
AND s.FK_COMPANY = c.PK_COMPANY
AND sr.PK_SRCREQ = r.FK_SRCREQ
GROUP BY
c.DISPLAY_TEXT
UNION
SELECT
c.DISPLAY_TEXT AS name,
MAX(DECODE(p.FK_COMPANY, s.FK_COMPANY, 1, 0)) isinuse
FROM
SOURCEREQUIREMENT sr,
SUBSCRIPTION s,
COMPANY c,
PROCESS p
WHERE s.FK_SRCREQ = sr.PK_SRCREQ
AND s.FK_COMPANY = c.PK_COMPANY
AND sr.PK_SRCREQ = p.FK_SRCREQ
GROUP BY
c.DISPLAY_TEXT
)
GROUP BY name[/code]

Thnx in advance
Mani

Nobody is going to be able to help you with this I'm afraid, as SQL can't be translated to HQL without contextual information like the database schema, hibernate mappings and java classes.

I suggest you search for some good HQL tutorials. If you get stuck with specific problems then post back.

Irons Uk is right.
We could translate this into a HQL query, but probably you would get the wrong answer.
You are selecting two fields from a subselction of an union of two selection in 4 different tables.
You have to map this correctly first. So tell us about your mapping schema, then we can try to help you.