please look at page 194 of the reference manual... >(and if so how do you ask MySQL to create a temp table from the > results of aquery?)
here's an example: mysql> create temporary table tmp (name varchar(20), owner varchar(20, species varchar(10)); mysql> insert into tmp select name, owner, species from pet where species='Dog'; These 2 statements put the results of the "select name, owner, species from pet where..." query in the temporary table tmp. thanks Nasser. ============================================================== How do you query the table that is the results of a query? Must you ask MySQL to... ....create a temporary table form the results of the first query ....then query that temporary table ....then delete the temp table when you are done? (and if so how do you ask MySQL to create a temp table from the results of a query?) Is there a better and faster way to do this with minimum burden on the web server with the db on it? Thanks for any help. Will --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php