Hi, Following error found while using following query
getHibernateTemplate().find("from Employee as emp where emp.employeeId in " + "(select empproj.employeeId from EmployeesProject as empproj " + "where empproj.projectId=?)", projectId+")"); Data Access Failure Error: could not resolve property: employeeId of: com.arrkgroup.pam.model.EmployeesProject [from com.arrkgroup.pam.model.Employee as emp where emp.employeeId in (select empproj.employeeId from com.arrkgroup.pam.model.EmployeesProject as empproj where empproj.projectId=?)]; nested exception is org.hibernate.QueryException: could not resolve property: employeeId of: com.arrkgroup.pam.model.EmployeesProject [from com.arrkgroup.pam.model.Employee as emp where emp.employeeId in (select empproj.employeeId from com.arrkgroup.pam.model.EmployeesProject as empproj where empproj.projectId=?)] Kindly guide me on how to refer the id Fields of the reference tables in to the query. Regards Trish -- View this message in context: http://www.nabble.com/Help-needed-for-Many-to-Many-relation-tp16547740s2369p16557807.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]