帮忙hql问题
sql:

select A.v_num,B.* from (select count(*) v_num,max(jsp_rootid) jsp_rootid1
from jsp_userpost where jsp_forum= '1 ' and jsp_rootid <> '0 ' group by jsp_rootid )
A right join (select * from jsp_userpost where jsp_forum= '1 ' and jsp_rootid= '0 ' )B
on A.jsp_rootid1 = B.jsp_postid order by B.jsp_posttime desc

hql:

String sql = "from (select count(*) num,max(jspRootid) jsp_rootid1 "+
" from jspUserpost where jspForum= '1 ' and jspRootid <> '0 ' group by jspRootid ) "+
" A right join (select * from jspUserpost where jspForum= '1 ' and jspRootid= '0 ' )B "+
" on A.jsp_rootid1 = B.jspPostid order by B.jspPosttime desc ";

hql要怎么写
jspUserpost是一个table的映射,我还要加上返回的num
请问这个hql要怎么写?

[解决办法]
HQL不支持from中的子查询，如果太复杂可以在数据库中建一个子查询的视图，在HQL中from这个视图