kuau
06-01-2008, 09:57 PM
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;
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;