Can a second query be based on temporary one? 1

[barrysprout]

I have 2 queries, the second of which simply groups the results of the first. I would like to do this in code without creating any saved queries, i.e. making the first query temporary. Can this be done and if so how? If not, is there another way?

 

[PHV]

A starting point:
SELECT A.*
FROM (SELECT blah blah) AS A

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886