Help Needed

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
 
M

Michel Walsh

Hi,


That is a matter of INNER joins. We don't really need table2, here.


SELECT Table3.TeamName, SUM(Table1.PlayerScore)
FROM Table3.PlayerName INNER JOIN Table1.PlayerName
GROUP BY Table3.TeamName



a look in the design view may even give a better feel of what is all about.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top