Hello all,
I am getting an exception when I am using HQL to join two tables. The query is:
select line from ListMap as map join ListLine as line on map.Idx = line.Idx

The exception which I get is: outer or full join must be followed by path expression.

I have tried different variations lke doing outer join etc.. in the HQL but to no avail.

Thanks in advance.

There is no "on" in HQL.

Thanks for your reply.
If HQL does not have a "on", how would I do I join on the a field. Does hibernate does it automatically on the primary key?

Thanks..

This is documented.

please simply add something to the hibernate document refering to the keyword "on".

lol, we should also add references to all the non HQL keywords in the spec ;-)