Posted by NC on 05/10/06 03:22

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]