join two tables in hibernate

[nidheesh ep]

How can I join two tables in hibernate. I have two tables User and Employee. My requirement is like,

SELECT userName,firstName FROM Employee AS emp LEFT JOIN User AS usr ON emp.userId=usr.userId. What I need to put in my pojo class. Employee is child class.
I have tried like, List<String> list = hibernateTemplate.find("from User usr left join usr.employee emp"); but it doesn't work. Since I am new to this, I need to know what else
I have to use in POJO class.

[vijin das]

hi nidheesh

check jboss docs

Associations and joins in Hibernate

check thistutorial also which may be helpfull.


Regards

[Hebert Coelho]

try like this "from Car c join c.ownder".