Query Problem

hi,
My problem is related to Mysql Query.

When you r writing a query say, SELECT ID, NAME FROM TABLE1, we get an output as
ID NAME
1 rat
2 cat


what i want is, i want to save this output as a separate table while writing the query itself, as we do in
SQL query like SELECT ID, NAME FROM TABLE1 AS TAB1, by writing a query like this in SQL, the output will be stored in a
temporary table called TAB1. I want to know whether we can do like this in MYSQL, becoz i tried and it didnt workout.

Thanks in advance for your assistance.
ri