hql 左连接查询

hql="select u from IxUserProject u left join (select new IxUserAttention(a.ixUserProject,COUNT(a.ixUserProject.projectId)) from IxUserAttention a group by a.ixUserProject.projectId)";

hql语句左连接怎么用，这么写为什么会报错啊！
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: ( near line 1, column 62 [select u from com.ixfund.ssh.beans.IxUserProject u left join (select new IxUserAttention(a.ixUserProject,COUNT(a.ixUserProject.projectId)) from com.ixfund.ssh.beans.IxUserAttention a group by a.ixUserProject.projectId)]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 62 [select u from com.ixfund.ssh.beans.IxUserProject u left join (select new IxUserAttention(a.ixUserProject,COUNT(a.ixUserProject.projectId)) from com.ixfund.ssh.beans.IxUserAttention a group by a.ixUserProject.projectId)]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:660)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)

at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
at com.ixfund.ssh.daoImpl.ProjectDaoImpl.findAllProjectByType(ProjectDaoImpl.java:165)
at com.ixfund.ssh.serviceImpl.ProjectServiceImpl.findProjectByPage(ProjectServiceImpl.java:158)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy6.findProjectByPage(Unknown Source)
at com.ixfund.ssh.action.ProjectAction.findProjectByPage(ProjectAction.java:419)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)

at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)