Posted by Bryan on 05/11/06 16:03

Well, I've got 2 tables so the solution below is missing just a bit. I've
added the structure since my original message..

Here's the structure...

tnumbers table: tid, mid, points
rollcall table: mid, here

I would like to list all tournaments now, along with the total amount of
meeting points (here*10), with the total of all tournaments plus the meeting
points.

Thanks...

--

...Bryan Cotter..
Texas Hawgs Guide Service - http://texashawgs.com
...512-762-0190..


"NC" <nc@iname.com> wrote in message
news:1147220567.167023.111710@g10g2000cwb.googlegroups.com...
> Bryan wrote:
>>
>> I'm trying to pull all the data fom the tournament table,
>> using 2 dropped tournaments, add to the total per angler
>> meeting points from the meetings table.
>
> Since you didn't say anything about the table structure, I had to make
> up field names. If I made them up correctly, this should work:
>
> SELECT SUM(points) AS total_points FROM tournament
> GROUP BY angler
> ORDER BY total_points DESC;
>
> Cheers,
> NC
>

[Back to original message]