Problem with Joins

amishra · **Posted:** Mon Jun 29, 2009 9:45 am

Hi I am new to Hibernate and I am trying to fetch data from a table by applying left outer join to it. But all I am getting is BusinessObjectException.
Can anyone help me in it?

Here is the Query:

Code:

@NamedQuery(name = "pm.lookup.getTimesheetNotSubmitOnLeave", query = "from Resource as res left outer join Select distinct rt.key.resource.resourceID as resourceID from ResourceTimesheet as rt where rt.key.week.weekId = ? as rts on (res.resourceID = rts.resourceID) where res.resourceName <> '--' and res.resourceIdentifier = 'Human' order by res.resourceName")