Query Problem

hi,
How are u all doing. Now i have found a problem. This is related to query. I want to put the output of a query in a separate table.

Like say, the output of a query "select * from table1" is,
Field1 Field2
1 orange
2 Lemon


I want to put this output in a separate table, like we do in sql query using "As" command.



Any help will be greatly appreciated

Thanks in advance
ri

I couldn't understood well pretty well, please be more specific, give examples.

But, is this?


Hope it helps

Sorry for i was not too specific.

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

You should really be posting this to the MySQL forum, but anyway.
What you want is slightly possible, it mostly depends on what you intend to do with it.
Easiest way is to join the table with itself (select * from table1 as tab1 inner join table1 as tab 2 etc)

Another way, more powerful, is with subqueries, but this hasn't been implement till MySQL 4.1, which is still in Beta.

good luck.