My goal is to take the results of a query and dump it into a temporary table for use and abuse.
My query starts off as a user defined search, looking for an ID (index).
Code: Select all
SELECT * FROM t1 WHERE t1_id = 'search_criteria'Code: Select all
SELECT * FROM t1 WHERE t1_id = 'search_criteria'
while(looping through t1 recordset) {
SELECT * FROM t2 WHERE t2_id = t1_t2_id
while(){};
SELECT * FROM t3 WHERE t3_id = t1_t3_id
WHILE(){};
}Can I do this as a JOIN?
The reason I want to do it in one query is to be able to easily make a temp table from the resulting recordset.
Any suggestions?
Thanks in advance!
-dstefani