Hi all,

How will I use left outer join in Hibernate?

I have one sample sql query

String sqlQuery="select ele.*,sub.submission_no,stu.*"
+" from element_data ele, submission sub,study_data stu"
+" where ele.submission_id=sub.submission_id"
+" and ele.study_id=stu.study_id(+)"
+" and ele.submission_id IN (select submission_id"
+" from submission s,application a"
+" where s.application_id=a.application_id "
+" and a.application_name='"+application_name+"' )";

Could anyoone give me sample hql query using left outer join for the
same.

Regards,
Sreekanth