hi
example query for the above problem :
select dept0_.deptid as deptid0_, emps1_.empid as empid1_, dept0_.deptname as deptname0_, emps1_.empname as empname1_, emps1_.dept_deptid as dept_dep3_1_, emps1_.dept_deptid as dept_dep3___, emps1_.empid as empid__ from dept dept0_ left outer join emp emps1_ on dept0_.deptid=emps1_.dept_deptid where (dept0_.deptid=? )
here emp table contains dept_deptid as fk
i m also getting the same error as
net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select dept0.deptid as deptid, emps.empid as empid, dept0.deptname as deptname, emps.empname as empname, emps.dept_deptid as emp_dept_depid, emps.dept_deptid as dept_dep3, emps1_.empid as empid from Dept dept0 left outer join Emp emps on dept0.deptid=emps.dept_deptid where (dept0.deptid='9')]
plz urgent reply to this
thnks
|