How to filter on joined table
I have three tables:
I want to select all games for which a particular
games and players and users. A user can join a game, at which point a player record is created with a unique constraint on game_id,user_id. I want to select all games for which a particular
player has joined. So, I need to filter on the joined players table. But how? Also, I want to include games whose column kind is open. So that will require some kind of or method, right?