Hey all,
Ran into a specific challenge with Left Joins. This site gave me the SQL answer, but unsure of the JPA-QL approach to solve the problem: http://forums.devshed.com/oracle-develo ... 83248.html

Inline example of the LEFT JOIN criteria for the ON clause below just in case link doesn't work:


The
and finances.month = 2
and finances.year = 2006
in the ON criteria are the important part I'm not sure how to do in JPA-QL (or in creating the associations).

Thanks for any help!

-D

Hi,

Before trying to write your query in JPA-QL there is one thing you should know, since Hibernate 3.1.3 the conditions in the ON clause can only refer to the right hand side of the join (in your case: finances). So "on departments.dept_id = ..." will generate an error!

http://opensource.atlassian.com/project ... e/HHH-1930

Sorry for the double post,

I've been a little too quick at answering your question.
In fact you should be able to write your query in JPA-QL.
If you define a One-To-Many relationship between departments and finances then the condition "on departments.dept_id = finances.dept_id" will be automatically created by Hibernate (you won't have to put it in your HQL query) and you shouldn't have any problem ...

Ah, thank you - so 'with' is the magic word, using the example in the link: