gruop by * 要与 select *的要对应 而你的没有 select distinct r.adno,r.fbmt,r.splbxxl,r.adversion,r.fstdate,...//r.fstdate group by r.adno,r.fbmt,r.splbxxl,r.adversion,r.adsc,...//r.adsc,...
select distinct r.adno,r.fbmt,r.splbxxl,r.adversion,r.fstdate, r.fbdate,r.mtlxdl,r.djr,r.fbnum,r.regdate,count(r.adxh),max(t.xh),min(t.applydate),max(t.applydate) from com.bpcc.multimedia.ggjg.po.ViewPmgg r LEFT JOIN com.bpcc.multimedia.ggjg.po.GgApprise t on r.adno=t.comp_id.adno group by r.adno,r.fbmt,r.splbxxl,r.adversion,r.fstdate, r.fbdate,r.mtlxdl,r.djr,r.fbnum,r.regdate order by r.fbdate asc 我改成这样的语句,在sql plus中可以执行,也能查出结果,但是,在java中执行时,报错。错误信息为: 执行Hibernate操作时发生异常,原因:outer or full join must be followed by path expression各位高手,帮帮忙,这是什么原因造成的?
select distinct r.adno,r.fbmt,r.splbxxl,r.adversion,r.fstdate,...//r.fstdate
group by r.adno,r.fbmt,r.splbxxl,r.adversion,r.adsc,...//r.adsc,...
我改成这样的语句,在sql plus中可以执行,也能查出结果,但是,在java中执行时,报错。错误信息为: 执行Hibernate操作时发生异常,原因:outer or full join must be followed by path expression各位高手,帮帮忙,这是什么原因造成的?