I am new to Hibernate. Following is a simple select statement that I am trying to replicate in HQL/JPA
select e1.*
from emp e1 left outer join emp e2
on e1.keyid = e2.pkeyid
where e1.empid = :empid

Can someone please let me know the correct syntax for this query in HQL. I have tried several options but it fails

like select e1
from emp e1 left join emp e2
on e1.keyid = e2.pkeyid
where e1.empid = :empid


or

select e1
from emp e1 left join emp e2
where e1.empid = :empid
and e1.keyid = e2.pkeyid

Do I have to add anything to the mapping file.
Thanks for your help.