Help with a Ruby on Rails query

Question

Good afternoon, I just started working with Rails and I’m having trouble with a query. I’m building an Api where I have the Game model and the User model. A user has several games, and one game has two users (there being an intermediate Gameusers table). When using the Rails console, I can easily see the users of a game making:

83 and 84 are the ids of users belonging to that game. But if I do

I can’t do a query to return the games to which two users belong. Can anyone help me with this? Thanks

Updating

After a while I found out it would be Game.joins(:users).where(users: { id: [83 && 84] })

Answer 1

In that case you need to make one joins with the table users.

Game.joins(:users).where(users: { id: [83, 84] }).

Take a look at these sections of the guide on Active Record Query Interface to have a better base:

• Conditions;
• Joining Tables.