At 6:32 -0400 5/12/02, Bill Easton wrote: >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?
Nope. > >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
