SUM problem.

Or if it's even SUM I should use..... well, on to describe my problem.

Ok, to make it short so I can understand a simple answer how to solve this :)

Ok, I have a database containing :

*Userinfo

*Tournamentinfo

*Resultinfo

Ok, what I info I have.

In a year we have 11 tournaments.

Not every user is in every tournament...

I want to "print" a sorted table based on the top 8 (out of the 11) results of the tournaments. (I hope that one made sense).

Lets say we have users (A,B,C,D,E... etc).

And we have 11 torneys (1,2,3... etc)

And then in result I save how many points each user gets in each torney....

So basicly A1=5, A2=0, A3=10 etc...

Now, if I wanted to SUM A1 - A11 (that's no problem), but what I want to do is just sum the top 8 out of A1 - A11, then sum the top 8 out of B1 - B11 and so on.

Then I want to show it sorted by the sum of the top8 results.

I have no problem sorting it by the sum of all 11, but how do I sort it by the sum of just the top 8 out of the 11 ?

I hope this all made sense on what I want to do.