• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB-QL IS MEMBER OF

 
Ramakrishnan Ponmudi
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
EJB-QL how to use IS MEMBER OF keywords in a query?
 
Muthaiah Ramanathan
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic