I have following table structure.

(1)
Table Name: Orders
requestedById
AssignedTO

(2)
Employee Table
employeeID
employeeName.

Now I have to retrieve names of requestedById and assignedTO in single query. I defined it as many-to-one from orders to employee, but it looks like I wrongly mapped. Obviously, I dont want to execute two queries to get the names. Any help is appreciated.

Thanks & Regards
Nagesh G


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

HQL: select o.requestedBy.name, o.assignedTo.name from Order o

Note:
- actual property names depend on your mapping;
- number of SQL queries depends on fetching strategies specified in mapping file
http://www.hibernate.org/hib_docs/v3/re ... -manytoone