Creating a table from the results of a query?

[kuau]

In phpMyAdmin, is there a way to create a table from the results of a query that takes data from multiple tables? Or maybe to load an existing table with the results of a query? Or do you need to do it from the shell?

This select command lists the data I want in my table, but how do I get it into the table? Thanks. e

SELECT SubscribeDate, Email, Value, ListName 
FROM `members` , `list_field_values` , `lists` 
WHERE members.MemberID = `list_field_values`.UserID 
AND `list_field_values`.FieldID =1 
AND `members`.ListID = `lists`.ListID 
ORDER BY `members`.`Email` ASC;

[tfit]

http://www.w3schools.com/SQL/sql_select_into.asp