求教一个HQL语句

SQL语句如下
SQL code

select * from  (select storenumber,storekeeper,areaid,paymenttype,dateclass, sum(paymentcap) as paymentcap,sum(adjustcap) as adjustcap from afterstorecommdata group by storenumber,storekeeper, areaid,paymenttype,dateclass) a left join AfterCommission b on(a.storenumber = b.storenumber and a.paymenttype = b.paymenttype and a.areaid = b.areaid ) left join Afterstorecommstatus c on (a.storenumber = c.storenumber and a.paymenttype = c.paymenttype and a.areaid = c.areaid and a.dateClass = c.dateClass) order by dateclass desc

用到了三个对象，afterstorecommdata ，AfterCommission ，Afterstorecommstatus ，这三个实体没有建立关系，以上SQL语句换成HQL语句该怎么写呢

该回复于2011-11-30 17:44:59被管理员删除

XiaoZZhao (XiaoZZhao) 等　级：

#2楼 得分：0回复于：2011-11-30 17:59:54 如果两个实体bean没有建立联系，用HQL语句是没有办法完成的，因为HQL是一种面向对象的机制，里面对象是大小写敏感的，你需要在bean里面建立联系，才能写出相应的HQL语句！