Mysql - Using rows from one query to use in another query
===

I have this 2 queries

1 - <code>SELECT iss.job , CEIL(Sum(If(returned_id > 0, - qty_iss_base * fvals_0 / 1000 * fvals_1 / 1000 * fvals_2 / 1000, qty_iss_base * fvals_0 / 1000 * fvals_1/1000 * fvals_2/1000))) AS Consumo , job.j_status FROM itm INNER JOIN (iss INNER JOIN job ON iss.job = job.j_number) ON itm.code = iss.item GROUP BY iss.job, job.j_status HAVING job.j_status < 20;</code>

This query I'll call it @var1

Now I need to use rows from this query and the query itself to use in another one:
I need the row Consumo from query 1 (@var1.Consumo), the row job (@var1.job) and the query itself @var1


2 - <code>SELECT req.item, req.raised, req.qty_req, qty_req * fvals_0 / 1000 * fvals_1 / 1000 * fvals_2 / 1000 AS kgs, @var1.Consumo, If(@var1.Consumo Is Null, kgs, kgs - @var1.Consumo) AS dif, req.required, req.job FROM itm INNER JOIN (req INNER JOIN job ON req.job = job.j_number ON itm.code = req.item LEFT JOIN @var1 ON job.j_number = @var1.job WHERE req.item Like "PCA%" AND job.j_status < 20 AND req.flags = 16;</code>

I cannot find any example on how to do it.
Any help will be appreciated.
Thanks