Hi everybody,
I have a query with SQL following:

select E.ID, E.FIRST_NAME, E.LAST_NAME, E.LOCATION, E.SALARY
from Employee E, Department D
where E.DEPT_ID = D.ID
and D.Name='Manager'

How do I write this query in HQL ?
Please help me !
Thanks

I'm not an expert but I believe this is the syntax assuming you want an Employee object returned and have properly mapped the relation:

from Employee as e
left join e.dept_id as d (I believe the "dept_id" is the member name of your pojo entity)
where d.name='manager'




http://docs.jboss.org/hibernate/core/3. ... ryhql.html

// Assume session already exists and want to retrive all fileds of employee record
Query qry = session.createQuery("select employee from Employee employee join Department dept where dept.name=:dname");
qry.setParameter("dname","Manager");
List<Employee> empList = qry.list();