Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table: team_players
- | id | team_id | player_id |
- ----------------------------
- 1 1 1
- 2 1 2
- 3 2 1
- 4 2 2
- 5 2 3
- I have 2 player_ids, 1 and 2.
- I want a query that tells me if that team already exists. (team_id 1 in the example above)
- Note that the same players can be on another team with more players (with player 3).
Add Comment
Please, Sign In to add comment