When I try to join a temporary table to itself, I get an error message, as
follows:
create temporary table TEMP (X int NOT NULL);
select * from TEMP A, TEMP B;
The select gives: ERROR 1137: Can't reopen table: 'A'
It appears to work as expected without the "temporary". Can I not join a
temporary table to itself?
Happens on:
Windows 2000: 3.23.47-nt
Linux 7.2: 3.23.49-max-log
Also happens on Linux with InnoDB instead of MyISAM.
sql,query
---------------------------------------------------------------------
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
