How to reference a temporary table in a subquery?

How to reference a temporary table in a subquery?

References

Reference NO 1

http://stackoverflow.com/questions/13649134/how-to-reference-a-temporary-table-in-a-subquery

Reference NO 2

http://gtowey.blogspot.com/2009/03/why-cant-you-use-subqueries-on-temp.html

Reference NO 3

http://dev.mysql.com/doc/refman/5.5/en/subqueries.html

Reference NO 4

http://dev.mysql.com/doc/refman/4.1/en/subquery-restrictions.html

Reference NO 5

http://dev.mysql.com/doc/refman/5.6/en/subquery-restrictions.html

Reference NO 6

http://www.oracle-base.com/articles/misc/with-clause.php

Reference NO 7

http://psoug.org/reference/with.html

Reference NO 8

#EANF#