custom query to db

Hi all, I have problem regarding querying database in rails database. Senerio: There are 2 models 'user' and 'interests' Association between them is has_and_belongs_to_many

Now If I want to list common interests between two users. How do I query db. I think, we have to write custom plsql statement. Can I know your thoughts.

Thank you, Aashish

?! user1.interests and user2.interests are just arrays.

You don't need a SQL statement to figure out the intersection of two arrays. :slight_smile: