Loading
Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.4
  Go To Table Of Contents
Contents
 Search
Other Searches
 PDF
PDF
Comments
Comments


ON

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:

Comments powered by Disqus