Results 1 to 4 of 4
Thread: Is it possible to query a query?
Sep 6, 2001, 06:43 #1
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
Is it possible to query a query?
I have a query which brings back a set of test scores for a student from a table that holds the scores for a whole class. Can I treat the $Result set that the query produces as a table and write things like:
$Result2="Select sum(testscores) AS ScoreTotal FROM $Result";
this could be rubbish I don't know?
I would like to do this as I want to first of all print all the data brought back from the first query and then process that data again to produce a total score for the student. I could just write a whole new query but would my suggestion be more efficient?