hql 左连接？

[zifeng858]

hql:语句

select new map(a.regino as regino,f.yhmc as yhmc,a.regtime as regtime ,b.brist as brist,d.invpt as invpt ,d.pttype as pttype,d.regno as regno,d.tel as tel,d.marname as marname,d.addr as addr,d.ubindtype as ubindtype,d.enttype as enttype,
    g.invobtype as invobtype,g.yiedistrict as yiedistrict,g.merimpsign as merimpsign,g.yieldly as yieldly,g.venspdistrict as venspdistrict,g.vensp as vensp,g.tmname as tmname,g.brandname as brandname,g.typespf as typespf,g.quan as quan,g.meaunit as meaunit) 
	      from TsclDjxx a, TsclNrxx b ,FkSazt d,TsclTgfxx e, Dwgl c ,Yhgl f,FkSakt g where c.dwbm =a.regdep  and f.yhbh=a.accregper and
          a.regino=b.regino and b.regino=d.regino and d.regino=e.regino and b.infotype=1 and a.dealno=g.dealno(+)

表FkSakt要和他左外连接，因为这个表可能没有数据，执行这条语句报错，主要是 g.dealno(+)，但是hibernate 又不支持左外连接，谁知道应该怎么改这条语句？？？

[测试逍遥子]

HQL不适合做复杂的查询，建议用原生SQL

[浴火涅磐]

楼主你写的简化些啊，表面看上去没有错误了，hibernate可以用子句来写

[zifeng858]

更改成如下:hql

select new map(a.regino as regino) 
	      from 
	      TsclDjxx a left outer join  FkSakt g on a.dealno=g.dealno,
	      TsclNrxx b ,FkSazt d,TsclTgfxx e, Dwgl c ,Yhgl f,FkSakt g
	       where c.dwbm =a.regdep  and f.yhbh=a.accregper and
          a.regino=b.regino and b.regino=d.regino and d.regino=e.regino and b.infotype=1

[zifeng858]

左连接怎么改？

[sunnyfun888]

left out join ...

[connor_zheng]

hql语句只查对像吧,外连接在hibernate配置文件中配置