HQL外连接写法

[color=red]SQL[/color]

select * from t_award aw RIGHT OUTER JOIN t_award_apply aa on (aw.c_apply_id=aa.c_id) LEFT OUTER JOIN t_system_option so on (aw.c_grade_id= so.c_id)

[color=red]HQL[/color]

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对表的连接效果相同