I have a ‘games’ table, in this table I have team1Id, team2Id, team1Score and team2Score.
team1Id & team2Id are INT and can be both ways, team1Id is the home team.
So one row might have teamID 3 vs teamID 6 where another might be 6 vs 3.
What I want to do is calculate how many times each team has one a game.
TeamID 3: 5 wins
TeamID 6: 12 wins.
Any idea how I can do this? – there could be 12+ teams
Help @kiwis spread the word by sharing this article on Twitter...Tweet This