mysql - Using the result of a complex query later to combine with another query -

i have complex query generates simple single column id list, use count number of rows. thereafter need ids generated first query combine result set of ( second ) query. how can preserve result set of first query achieve binding second query ? thank you.

with temporary table:

create temporary table tmp_result [first long complex query here];

(you may wish add index here, depending on nature of rest of work.)

//create index tmp_result_x on tmp_result(some_col_name);