HQL = select depGg,sysclime.areaName as climename from DepGg as depGg,SysClime as sysclime where depGg.climecode=sysclime.areaCode
Error in query :
select depGg,sysclime.areaName as climename from DepGg as depGg,SysClime as sysclime where depGg.climecode=sysclime.areaCode
Error in query :
net.sf.hibernate.QueryException: , expected in SELECT [select depGg,sysclime.areaName as climename from com.sunhoo.notary.organ.hibernate.DepGg as depGg,com.sunhoo.notary.admin.purview.hibernate.SysClime as sysclime where depGg.climecode=sysclime.areaCode]
ApplicationDispatcher[/Notary_Web]: Servlet.service() for servlet debugjsp threw exception
换成上句后出错提示为:
Error in query :
net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select depGg.id as ID,sysclime.areaName as climename from com.sunhoo.notary.organ.hibernate.DepGg as depGg join SysClime as sysclime on depGg.climecode=sysclime.areaCode]
换成select depGg.id as ID,sysclime.areaName as climename from DepGg as depGg join SysClime as sysclime on depGg.climecode=sysclime.areaCode这句也
出错,请问你们能用hibernate实现联合查询吗?我怎么试都不行,最好给个实例