Help Required for createSQLQuery()

kalramadevi03 · **Posted:** Thu Aug 24, 2006 10:37 am

Hi..

I am trying to reteive columns for diffent tables within an SQL query.

For example:

Let EMPLOYEE, DEPT are two tables.

My Query is as follows:

select emp.empID, dept.deptID from EMPLOYEE emp join DEPT dep on emp.deptID = dep.deptID

how should my createSQLQuery should be and once i get my list how can I retrieve empId and deptId.

Thanks & Regards
Ramadevi K

denis.etienne · **Posted:** Thu Aug 24, 2006 2:56 pm

select emp.id, dpt.id from Employee emp join emp.dept dpt

pepelnm · **Posted:** Fri Aug 25, 2006 5:01 am

Code:

String sql = "select emp.empID, dept.deptID from EMPLOYEE emp join DEPT dep on emp.deptID = dep.deptID";
List<Object[]> ids_list = session.createSQLQuery(sql).list();
for(Object[] ids : ids_list) {
   //ids[0] is empID
   //ids[1] is deptID
}

Please, don't forget to rate.