hibernate 查询 各位大仙帮忙改改 谢了~解决方法

hibernate 查询 各位大仙帮忙改改 谢了~~~
query=session.createQuery("from Seedlingforecast aps where fid in(select min(fid) from Seedlingforecast group by (aps.pest.pno and aps.countryseedling.csno))");

[解决办法]
FROM Event as t where t.id in (SELECT min(t1.id) from Event as t1 group by t1.date,t1.title)
类似的没有问题啊
from Seedlingforecast aps where aps.fid in(select min(aps1.fid) from Seedlingforecast aps1 group by aps1.pest.pno,aps1.countryseedling.csno)