|
|
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
Navigation:
[Reply to this message]
|