Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.4
ON clause to append additional conditions to a
JOIN condition, such as for outer joins.
EclipseLink 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: