就是有四个对象A,B,C,D
hibernate语句是
select a.name,a.bname,a.cname,a.dname a.anumber,b.number from (select count(A.tpid) anumber,A.name,B.bname,C.cname,D.dname where A.id=B.id and A.uerid=c.uerid and A.tpid=d.tpid and A.sex='1' group by A.name,B.bname,C.cname,D.dname ) aselect count(A.tpid) anumber,A.name,B.bname,C.cname,D.dname where A.id=B.id and A.uerid=c.uerid and A.tpid=d.tpid and A.sex='2' group by A.name,B.bname,C.cname,D.dname ) b where a.name=b.name and a.bname=b.bname and a.cname=b.cname and a.dname=b.name
大家看看错再什么地方啦,还是这样写本来就不对呀,在pl/sql中换成对应的表和表字段可以顺利执行,但是换成对象在hibernate中就出错啦
hibernate语句是
select a.name,a.bname,a.cname,a.dname a.anumber,b.number from (select count(A.tpid) anumber,A.name,B.bname,C.cname,D.dname where A.id=B.id and A.uerid=c.uerid and A.tpid=d.tpid and A.sex='1' group by A.name,B.bname,C.cname,D.dname ) aselect count(A.tpid) anumber,A.name,B.bname,C.cname,D.dname where A.id=B.id and A.uerid=c.uerid and A.tpid=d.tpid and A.sex='2' group by A.name,B.bname,C.cname,D.dname ) b where a.name=b.name and a.bname=b.bname and a.cname=b.cname and a.dname=b.name
大家看看错再什么地方啦,还是这样写本来就不对呀,在pl/sql中换成对应的表和表字段可以顺利执行,但是换成对象在hibernate中就出错啦