I am using hibernate 3.0. I am applying the right outer join. my query is
List<Integer> phaseCount1 = getHibernateTemplate().find("select count(phasesPlan.phaseid.id) as Phase from PhasePlan phasesPlan RIGHT JOIN " + "phasesPlan.phaseid as phasedetails and phasesPlan.teamid.teamid=? group by phasedetails.id",team_id);
in this the and condition (
phasesPlan.phaseid as phasedetails **and** phasesPlan.teamid.teamid=? ) is giving unexpected token exception.
Any help would be appreciated.