Hi -

I am using Hibernate 2.1.6 and would like to to build a query in HQL for the following SQL query:

select emp.Name from EMPLOYEES emp
inner join EVENTS v
on emp.GROUP_ID = v.GROUP_ID

The tables are:

EMPLOYEES: columns> Name, GROUP_ID
EVENTS: columns> GROUP_ID, EventName

This basically joins the two tables EMPLOYEES and EVENTS on their comment column GROUP_ID.

What could the HQL query for this in XDoclet look like?

I tried the following and it doesn't work:

@hibernate.query name="myQuery" query="from EMPLOYEES as emp join EVENTS as v on emp.GROUP_ID = v.GROUP_ID


I get the following exception:

"Caused by: net.sf.hibernate.QueryException: outer or full join must be followed by path expression "

Any help will be appreciated! Thanks.

OK, so if we propose Your mapped object classes are (EMPLOYEES and EVENTS) ... because it is the object names that matter not the table names ?! ... than I would give it a try to remove the alias for the JOIN Class (I had some issues with aliases in Hibernate 3.0.x ... but I am absolutely not sure if this is Your problem):



of course this proposes than Employees object does have an GROUP_ID property (CASE SENSITIVE ?) etc.

EMPLOYEES and EVENTS are two classes that are not mapped.
I've seen a lot of examples from the Hibernate reference guide for objects that have a parent to child relationship but my two objects are not mapped. Hence I am trying to come up with a query for the @hibernate.query tag.
Thanks.