HiberNate--->select语句 请高手帮帮忙

[java_xf]

表1
aa bb
2008-10-1 1
2008-10-2 1
2008-11-1 2
2008-12-1 3
表2
cc dd
2008-10-1 2
2008-10-2 2
2008-11-1 2
2008-11-2 2

表3
ee ff
2008-09-1 2
2008-10-1 2

统计出像下面这个表
表4
月份 bb dd ff
2008-09 0 0 2
2008-10 2 4 2
2008-11 2 4 0
2008-12 3 0 0


这个是SQL语句

select Tdate,bb,0 as dd, 0 as ff
from
(select sum(bb) as bb,year(convert(dateTime,aa,101) )+month(convert(dateTime,aa,101) ) as Tdate
from 表1
group by Tdate) AS A
union all
select Tdate,0 as bb,dd,0 as ff
from
(select sum(dd) as dd,year(convert(dateTime,cc,101) )+month(convert(dateTime,cc,101) ) as Tdate
from 表2
group by Tdate
) AS B
union all
select Tdate,0 as bb, 0 as dd, ff
from
(select sum(ff ) as ff ,year(convert(dateTime,ee,101) )+month(convert(dateTime,ee,101) ) as Tdate
from 表3
group by Tdate
) AS C
order by Tdate

请大家帮忙，写一下HIBERNATE 语句！谢谢

[Johnson_Hong]

建议你看一下hibernate的文档
Chapter 16. Native SQL

[ks_ly]

你为什么要用hibernate.这么长的hql用sql多好。

[sebatinsky]

select count(payment), status.name
from Payment as payment
join payment.currentStatus as status
join payment.statusChanges as statusChange
where payment.status.name <> PaymentStatus.AWAITING_APPROVAL
or (
statusChange.timeStamp = (
select max(change.timeStamp)
from PaymentStatusChange change
where change.payment = payment
)
and statusChange.user <> :currentUser
)
group by status.name, status.sortOrder
order by status.sortOrder

呵呵,是没有from嵌套的,不过可以用左右连接,楼主去下一个Hibernate的中文文档来看看就很清楚了,按照要求的欧普可以写.

[Johnson_Hong]

hql不支持from嵌套吧，可以分3次查询，然后在java程序合并
或者干脆就用nativeSql

[java_xf]

Johnson_Hong ，你可以给个建议或者是思路吗？
已经想了两天了，也写不出来。