It seems like that HQL does not recognize "inner join on" syntax. It accepts inner join, but if you specify "on" condition, it blows up.

I understand how to define OneToOne, OneToMany etc in JPA, but is that the only way? what if I want to specify join in my createQuery() call?

Just thought to follow up on my own post... There is an Hibernate bug open for this. It has been there for a while, and doesn't look like anybody is going to fix it any time soon.

Hi In the mean while u can use the query some thing like.

select * from emp where id in () or not in ()

it will be just like your outer join

Thanks for the updates!

Sometimes it might feel like you're talking to yourself, but there are lots of people hitting this thread with the same question.