sql语句换成hql
select m.c2,m.c3,m.c4, d.id,d.orderId from AtdProcRec d, (select a.deptName c2,b.emplId c3,b.emplName c4 from HrDept a,HrEmployee b where a.deptNo=b.deptId) m where d.emplId=m.c3 and d.id.recDate like '"+Month+"%'
在hibernate中会出错,在sql中可以,请大家帮忙看看,谢谢。