Originally Posted by Old Pedant
Can you show some sample data?
Maybe just the data for one team?
Sure, and sorry for not providing this in the first post:
The team_member_scores has the following columns and data:
username - game_id - team_id - points
Fred - 1 - 1 - 200
Joe - 1 - 1 - 600
Aaron - 1 - 2 - 500
and the team_members has the following info:
team_id - username - stage - join_date
1 - Fred - 1 - timstamp
The username is being used as the foreign key in the team_member_scores table (I didn't design the team_members table, but I can redesign it if you think it would be better.)
I hope that clears it up.