I am starting to learn JPA and have implemented an example with JPA query based on the following native SQL that I tested in SQL Server SELECT f StudentID f Name f Age f Class1 f Class2 FROM Student f LEFT OUTER JOIN ClassTbl s ON s ClassID f Class1 OR s ClassID f Class2 WHERE s ClassName abc From the above SQL I have constructed the following JPQL query SELECT f FROM Student f LEFT JOIN f Class1 s As you can see I still lack the condition OR s ClassID f Class2 from my original query My question is how can I put it into my JPQL

How to create a JPA query with LEFT OUTER JOIN

Write this;

 SELECT f from Student f LEFT JOIN f.classTbls s WHERE s.ClassName = 'abc'

Because your Student entity has One To Many relationship with ClassTbl entity.

~ Answered on 2012-04-18 04:45:17