Hi,
I have this pretty complex query which uses two temporary tables.
The first temporary table ( T1 ) is created as a result from query 'A'
The second temporary table is created as result from a query based upon
temporary table one ( T1 ). At this point I get the message
ERROR 1137: Can't reopen table: 'mj_tmp_diag' <--- This is T1
Is it that I can't use two temporary tables this way?
What can I do to solve this problem?
The error shows when I execute the whole query under MySql Control
Center.
Mysql version is 4.1
Thanks in advance ,
Mauricio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
