Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Difference between MEMBER OF and IN operators  RSS feed

 
Dilshan Edirisuriya
Ranch Hand
Posts: 299
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the difference between MEMBER OF and IN operators? Both look simillar to me. What are the scenarios that we have to use those operators specifically.
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With the IN syntax, you cannot use Collections. You have to use a list of strings, or a subquery. With MEMBER OF, you can use a Collection (association-field in a one-to-many or a many-to-many relationship).
 
Dilshan Edirisuriya
Ranch Hand
Posts: 299
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Christophe
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!