Hi,

I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html

"You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql> SELECT * FROM temporary_table, temporary_table AS t2;"

Does it mean that I can't use THE SAME temporary table twice in THE SAME
query?
Or does it mean that I can't use more than 1 temporary table in the query at
all?

Thanks in advance,

Mikhail.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to