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

I beleive the following query should give you the same equivalent:

Hi,

Thank u for your valuable information. I tested the same query and itis working fine.

Once again thanks for your assistance.


Regards,
Sreekanth

Chapter n HWL explains in detail.

Anand
PS:Don't forget to Rate.