Use the ON
clause to append additional conditions to a JOIN
condition, such as for outer joins.
Oracle TopLink supports using the ON
clause between two root level objects.
Example 3-9 shows how to use this JPQL extension.
Example 3-9 Using ON Clause EQ
SELECT e FROM Employee e LEFT JOIN e.address ON a.city = :city
SELECT e FROM Employee e LEFT JOIN MailingAddress a ON e.address = a.address
For more information, see: