String hql = "select new SysEmployee(se.sysSortByEmDepartment.sortId,c_department.sortName,se.sysSortByEmPost.sortId,c_post.sortName)from SysEmployee se left join se.sysSortByEmDepartment as c_department left join se.sysSortByEmPost as c_post where se.emId=:emId";