Java Persistence API (JPA) Extensions Reference for EclipseLink,
Release 2.5 |
|
 |
 |
Use the ON clause to append additional conditions to a JOIN condition, such as for outer joins.
Usage
EclipseLink supports using the ON clause between two root level objects.
Examples
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
See Also
For more information, see:
