cyw521
梦一场丶
2017-03-21 01:19
采纳率: 66.7%
浏览 4.6k
已采纳

hql语句左连接查询报错 Path expected for join!

String hql=" select new Map(o.id as id,o.regno as regno,o.uniscid as uniscid , o.entname as entname,o.lerep as lerep ,o.estdate as estdate,o.dom as dom, o.tel as tel , o.datasource as datasource ,d.nr as djjg ) from DataQyfrEntity o LEFT JOIN ABmDjjgEntity d with (d.bm=o.djjg) ";
图片说明


  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • qq_36527577
    qq_36527577 2017-03-21 03:46
    已采纳

    LEFT JOIN ABmDjjgEntity d with (d.bm=o.djjg);连接查询用的是on,不是with吧。。。

    点赞 评论
  • HackAge4619

    应该是sql语法的错误,先拿到PL/SQL中测试看是否能通过,有错它会提示的

    点赞 评论
  • quantum_
    少彬。。 2020-04-18 20:05

    on 替换 where

    点赞 评论

相关推荐