一个关于HQL的连接查询
我写了一个关联查询,语句如下:
select zd.bianma ,zd.mingcheng,zd1.bianma,zd1.mingcheng,zd2.bianma,zd2.mingcheng
from com.gwssi.police.framework.component.dictman.dataservice.orm.pojo.DictTyzd zd
left outer join com.gwssi.police.framework.component.dictman.dataservice.orm.pojo.DictTyzd zd1 on zd.bianma=zd1.fbh
left outer join com.gwssi.police.framework.component.dictman.dataservice.orm.pojo.DictTyzd zd2 on zd1.bianma=zd2.fbh
where zd.fbh='1005001' order by zd.bianma,zd1.bianma,zd2.bianma
但是放在java代码中执行的时候报:outer or full join must be followed by path expression
这是为什么?有什么解决的方案吗