HQL Query
select p.name from Person p left outer join PersonEvent pe on p.personId=pe.person.personId

In PersonEvent table personId is foreign key of Person table.
Person table is having one-to-many relation with PersonEvent

I am getting exception : outer join or full join must be followed by path expression
If I modify above query with following one then it executes fine.

select p.name from Person p left outer join p.personEvents pe

Here personEvents is set having PersonEvent objects.


Please suggest me a solution.


Thanks,
kuldeepak

Hi kuldeepak,

use

select p.name from Person p left fetch join p.personEvent

Hi,
Thanks for your suggestion but it will work only if two tables have relation in between.If two tables don't have relation in them then 'on' clause will be needed which throws exception

Thanks,
Kuldeepak