I have a HQL statement like this:
"from Course_Info as c, Courses as s
where c.id = s.courseId and s.courseCode = 13 order by c.id"

I didnot define any association between Course_Info and Courses.
Now the problem is that I want to use left outer join.
because there is no association between Course_Info and Courses.
I cannot use HQL like this "from Course_Info as c left join Courses as s
where s.courseCode = 13 order by c.id".

the Native SQL createSQLQuery(String , String, Class) only accept one class, but I want to get two class, Course_Info and Courses. just like my first HQL statement does.

First, why don't you actually declare the association between the two entities in your mappings?

Second, your HQL query should read



Don't forget to put the resulting List in a Set to eliminate potential duplicates...