EJB-QL IS MEMBER OF

[Ramakrishnan Ponmudi]

EJB-QL how to use IS MEMBER OF keywords in a query?

[Muthaiah Ramanathan]

From the spec:
collection_member_expression ::=
{single_valued_navigation | identification_variable | input_parameter}
[NOT] MEMBER [OF] collection_valued_path_expression

Examples:
SELECT OBJECT(c) from Customer c, IN Address a where c.Address MEMBER OF a

SELECT c.name from Customer c, IN Order o where c.address MEMBER OF o.address