P
PlusNet
I have three tables:
Table1
PlayerName
PlayerScore
e.g. Paul 15
Peter 12
John 10
Tom 12
Chris 9
Table2
TeamName
e.g. Chelsea
Wolves
Spurs
Table3 - a mapping table, showing each team's players
TeamName
PlayerName
e.g. Chelsea Paul
Chelsea Peter
Arsenal John
Arsenal Peter
I need a query, presumably a crosstab one, which will show a league table.
That being the combined points total for each team the total being the total
of the scores of each player on the team.
PWS
Table1
PlayerName
PlayerScore
e.g. Paul 15
Peter 12
John 10
Tom 12
Chris 9
Table2
TeamName
e.g. Chelsea
Wolves
Spurs
Table3 - a mapping table, showing each team's players
TeamName
PlayerName
e.g. Chelsea Paul
Chelsea Peter
Arsenal John
Arsenal Peter
I need a query, presumably a crosstab one, which will show a league table.
That being the combined points total for each team the total being the total
of the scores of each player on the team.
PWS