Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Difference between MEMBER OF and IN operators

 
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