Hi,
I have come across a query which is just too difficult to do at once so I have decided to split it up into several simpler queries.
I want to do the first query (3 variables come from html form), store the results,
then, do the second query based on the stored reults, then store these results,
then do the third etc etc
until I get the answer.
Is this possible? The query is only a select statement (no insert/delete/update).
Thanks!
I have come across a query which is just too difficult to do at once so I have decided to split it up into several simpler queries.
I want to do the first query (3 variables come from html form), store the results,
then, do the second query based on the stored reults, then store these results,
then do the third etc etc
until I get the answer.
Is this possible? The query is only a select statement (no insert/delete/update).
Thanks!