league table

[J]

hi,

i have a table with 40 players containing
PLAYERNAME,TEAM, and 20 weeks worth of score data.

what i want is to create another table with 6 rows
containing a record for each TEAM, and totalling the
scores for each player. (basically a league table of the
teams)

the players can belong to more than one team tho

i.e

PLAYER TEAM wk1 wk2 wk3 wk4
player1 team1 2 3 4 5 ......etc
player2 team1, team2 2 4 5 8 ......etc
player40 team3, team6 5 4 1 2 ......etc


i want to get :

TEAM TOTAL POINTS
team1 sum totals for each player in team 1
team2 sum totals for each player in team 2
team6 etc etc


hope you can help
Thanks
J