Question

hql语句问题 在线等..求大哥大姐帮忙,不甚感激

不多说,直接上语句
SELECT DISTINCT(app.AppName),COUNT(*) from (SELECT (applog.AppId) as bb FROM t_department as dept,t_v_license AS lic,t_application_log AS applog WHERE dept.DepartmentId = 1001060001 AND lic.DepartmentId = dept.DepartmentId AND lic.LicenseId = applog.LicenseId AND applog.ClickType = 1 AND applog.ClickTime BETWEEN "2013-05-01" and "2013-06-30") AS a,t_v_application AS appWHERE app.AppId = a.bb GROUP BY app.AppName
以上是sql语句 ,已通过测试
SELECT DISTINCT (app.appName) , COUNT(*) from (SELECT applog.id.appId FROM TDepartment as dept,TLicense as lic,TApplicationLog as applog WHERE dept.departmentId = 1001060001 AND lic.departmentId = dept.departmentId AND lic.licenseId = applog.id.licenseId AND applog.id.clickType = 1 AND applog.id.clickTime BETWEEN '2013-05-01' and '2013-06-30' ) as a,TApplication AS app WHERE app.appId = a.appId GROUP BY app.appName
以上是我转的hql语句.报错!!!

hql语句已通过测试.但是 全部加上之后就不行了. 我琢磨是 where后面的问题.不知道怎么办了.求解啊!!!
上面附图的内容想要说明的是子hql语句的子查询已经通过测试!!

Answer 1

HQL不是支持子查询的，不能在一个查询的外边在套一层查询哈。只有换中查询方式了。

Answer 2

HQL不是支持子查询的，不能在一个查询的外边在套一层查询哈