I have an SQL query and i want to convert it into a HQL query:

SELECT MESSAGES.MESSAGEID, MESSAGES.TYPE, MESSAGES.AREA, MESSAGES.FLOW, MESSAGES.OTHERFLOWINFO,
MESSAGES.DATECREATED, MESSAGES.DATELASTUPDATED, MESSAGES.CONTEXT, MESSAGES.STATUS, MESSAGES.PARENT,
PROBTRACKING.USERID
FROM MESSAGES
LEFT OUTER JOIN PROBTRACKING
ON MESSAGES.MESSAGEID = PROBTRACKING.MESSAGEID
AND PROBTRACKING.PROBLEMSTATUS = 'Unresolved'

Can this be done, i don't want to use create SQL query for this as i have filters set up, Struggling a lot with the syntax!

Any help is much appreciated,

Thanks

Assuming messages<>probtracking is many-to-one.

Can you show the mappings?

Thanks for the help!

Unfortunately i am still lost.

In the messages table there are unique message id's

in the problem tracking table there are many problems which may be linked to the one message id but only one message id will have prob status = 'Unresolved'

My hibernate layer has no foreign keys set up, i was hoping to jus write a query like the one shown in SQL which produces the correct results!

Any help muchly appreciated!

Thanks again.

have you looked at
[url]
http://www.hibernate.org/hib_docs/v3/re ... references[/url]

i was thinking something like

session..createSQLQuery(sql)
.addEntity("msgs", Messages.class)