求教这条HQL语句错在哪里？

String hql=" from ( select new ZyCrmLoanCustomer(a.loanOfficerId as remake,a.name as remake1,a.phone as remake2,a.sex as remake3,b.bank as remake4,b.address as remake5,b.linkName as linkName) from ZyCrmLoanOfficer a,ZyCrmBankType b where a.bankId = b.bankId ) as c left join ZyCrmLoanCustomer d  on c.remake = d.userId ";

是不是没有表，不好判断呢？

[ 本帖最后由 xf626381061 于 2011-12-12 16:35 编辑 ]