undefined token :on (left outer join)

kotigattineni · **Joined:** Sat Jul 16, 2011 12:52 am **Posts:** 3

i am using left outer join in hibernate (Native sql query)

Select * from emp e left outer join dept d on e.deptno = d.deptno

I got exception Undefined token ON

How to resolve this problem..

lokeshc · **Joined:** Thu Apr 21, 2011 8:59 am **Posts:** 14

Not sure if you are trying to execute SQL or HQL.
If its HQL, I do not think you can use "ON", instead you can specify "WHERE" there.
If its SQL, you will have to provide the table names instead of saying "emp e"

kotigattineni · **Joined:** Sat Jul 16, 2011 12:52 am **Posts:** 3

Thanking you for reply me,

I tried to change instead of ON to where
at this time i got another exceptions...
i.e path expected for join and unexpected end of sub tree

kotigattineni · **Joined:** Sat Jul 16, 2011 12:52 am **Posts:** 3

Please give solution for this issue...