Base a query on a query.

[crystalreef]

Hi,

I have created a stored procedure in mysql. It bassically calculates scores for people in a competition. So on day one they might get 4, day two 5 etc etc.

I now want to sum the calculated score field that the stored procedure computes but have no idea how to do it.

I am very familiar with Access and new at MYSQL. In Access I create a computedailyscores query and then do another query that sums the computerdailyscore field.

How would I do this in mysql?

Cheers

[r035198x]

Hi,

I have created a stored procedure in mysql. It bassically calculates scores for people in a competition. So on day one they might get 4, day two 5 etc etc.

I now want to sum the calculated score field that the stored procedure computes but have no idea how to do it.

I am very familiar with Access and new at MYSQL. In Access I create a computedailyscores query and then do another query that sums the computerdailyscore field.

How would I do this in mysql?

Cheers

Does your stored procedure take the date as a parameter?

You can use the same approach you used in Access as well.

[crystalreef]

Does your stored procedure take the date as a parameter?

You can use the same approach you used in Access as well.

Thnaks for the quick response.

There is no date in the stored procedure as yet, there maybe in the future though. Does this matter?

In access I would just reference the query in the from statement like

Select fields
From QueryName

When I do this in MYSQL query browser I just get an error saying the table doesn't exist. I just can't seem to find how to reference the stored procedure.

[r035198x]

Thnaks for the quick response.

There is no date in the stored procedure as yet, there maybe in the future though. Does this matter?

In access I would just reference the query in the from statement like

Select fields
From QueryName

When I do this in MYSQL query browser I just get an error saying the table doesn't exist. I just can't seem to find how to reference the stored procedure.

Do you mean procedure or view then? In MYSQL you can select from a view.

[crystalreef]

I have currently done it as a procedure.