fishing tournament results

[Bryan]

Well, I've got 2 tables I'm wanting to pull date from sorted by most points
asc.

Here's the structure...

tnumbers table (holds all tournament points: tid, mid, points
rollcall table: mid, here

I would like to list all tournament results in a row, along with the total
amount of meeting points (here*10), with the total of all tournaments plus
the meeting points. I would like these listed all in 1 row per angler...

example:
Angler Jan Feb Mar Apr May Meetings Total
Kevin VanDam 60 37 45 32 50
174
Ish Monroe 50 40 38 42 50
170
etc, etc...

Thanks so much...

[Bill Karwin]

Bryan wrote:

Here's the structure...

tnumbers table (holds all tournament points: tid, mid, points
rollcall table: mid, here

This isn't enough information to answer the question. We have no idea
what any of these columns contains, and it's hard to infer from the
names. For instance, which column contains the name of the angler? Are
any of these columns dates? There is no way for readers to guess.

When asking questions like this, please post the results of SHOW CREATE
TABLE for each of these tables, and describe the meaning of the columns.
Even better would be a few rows of sample data.

Anyway, I am guessing that the following article may help you do what
you want:

http://dev.mysql.com/tech-resources/...ard/index.html

Regards,
Bill K.