HQL外连接写法SQLselect aa.id, aa.productType.name, aa.awardType.name, aa.applyDate, so.name from Aw
HQL外连接写法
SQL
select aa.id, aa.productType.name, aa.awardType.name, aa.applyDate, so.name from Award aw, AwardApply aa, SystemOption so where aw.awardApply.id(+)=aa.id and so.id(+)=aw.awardGrade.id
以上sql与hql对表的连接效果相同