Question

Delete double matches

0

I have created all possible matches for every player in a list. Then I have deleted al matches where player 1 = player 2. The last step I have to take is to delete all double matches. For example player 1 - player 2and player 2 - player 1 is a double match. How can I delete these double matches? The model consists of two tables: - players - matches With 2 assosiations, for 2 players.

asked 2015-12-30

Patrick Holterman

1 answers

Nikel Kruizinga · Answer 1 · 2015-12-30

My first idea is to make sure every player has an autonumber attribute uniqueId.

Now retrieve all matches where player 1's uniqueId is less than player 2's uniqueId. And then delete them.