2.10.2.3.9. JPQL Collection Member Declarations
An identification variable declared by a collection_member_declaration ranges over values of a collection obtained by navigation using a path expression.
Such a path expression represents a navigation involving the association-fields of an entity abstract schema type.
Because a path expression can be based on another path expression, the navigation can use the association-fields of related entities.
An identification variable of a collection member declaration is declared using a special operator, the reserved identifier IN . The argument to the IN operator is a collection-valued path expression.
The path expression evaluates to a collection type specified as a result of navigation to a collection-valued association-field of an entity or embeddable class abstract schema type.
The syntax for declaring a collection member identification variable is as follows:
-
collection_member_declaration ::= IN (collection_valued_path_expression) [AS] identification_variable
For example, the query
SELECT DISTINCT mag FROM Magazine mag
JOIN mag.articles art
JOIN art.author auth
WHERE auth.lastName = 'Grisham'
can equivalently be expressed as follows, using the IN operator:
SELECT DISTINCT mag FROM Magazine mag,
IN(mag.articles) art
WHERE art.author.lastName = 'Grisham'
In this example, articles is the name of an association-field whose value is a collection of instances of the abstract schema type Article.
The identification variable art designates a member of this collection, a single Article abstract schema type instance.
In this example, mag is an identification variable of the abstract schema type Magazine.