outer or full join must be followed by path expression怎么解决

答案:2 悬赏:70 手机版

解决时间 2021-02-15 20:08

提问者网友：沦陷
2021-02-15 10:50

我用的是hibernate 1的版本
语句是hql = "from TbJbjxx tbJbjxx left outer join TbSaryjbxx tbSaryjbxx on tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid where tbJbjxx.shanchubiaoji='0' ";

报错：outer or full join must be followed by path expression [from com.zgjx.police.zfba.dataservice.orm.jiebaojing.pojo.TbJbjxx tbJbjxx left outer join TbSaryjbxx tbSaryjbxx on tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid where tbJbjxx.shanchubiaoji='0' and tbJbjxx.jbdwbh like ? and jieguoleixing is null order by tbJbjxx.jbjxxid desc ];

哪位高手帮我解决，谢谢了急急急》》》》》》》》》》》》。。。

我尝试过其他写法// hql = "from "+pa+"TbJbjxx tbJbjxx where tbJbjxx.SHANCHUBIAOJI='0' ";
//on tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid
// hql = "from (select * from "+pa+"TbJbjxx tbJbjxx2 left outer join "+pa+"TbSaryjbxx tbSaryjbxx on tbJbjxx2.bjrywslbh=tbSaryjbxx.saryjbxxid )tbJbjxx where tbJbjxx.shanchubiaoji='0' ";
// hql=" from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbJbjxx.* in (select * from tbJbjxx left outer join tbSaryjbxx on tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid where tbJbjxx.shanchubiaoji='0' ";
// hql=" from TbJbjxx tbJbjxx left outer join TbSaryjbxx tbSaryjbxx and tbJbjxx.bjrywslbh=to_char(tbSaryjbxx.saryjbxxid) where tbJbjxx.shanchubiaoji='0'";

// hql="from TbJbjxx tbJbjxx,(select tbSaryjbxx.* from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid) where tbJbjxx.shanchubiaoji='0'";

// hql="from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbSaryjbxx.saryjbxxid in(select tbSaryjbxx.saryjbxxid from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid) and tbJbjxx.shanchubiaoji='0'";

// hql="from (select tbJbjxx.*,tbSaryjbxx.* from(select distinct(tbJbjxx.jbjxxid),tbJbjxx.*,tbSaryjbxx.* from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbSaryjbxx.saryjbxxid in(select tbSaryjbxx.saryjbxxid from TbJbjxx tbJbjxx,TbSaryjbxx tbSaryjbxx where tbJbjxx.bjrywslbh=tbSaryjbxx.saryjbxxid)))and tbJbjxx.shanchubiaoji='0' ";都有问题

最佳答案

五星知识达人网友：罪歌
2021-02-15 11:15

用sql Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;

全部回答

1楼网友：蕴藏春秋
2021-02-15 11:37

你好！ rbytbyrt 希望对你有所帮助，望采纳。

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息