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
> 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?
> Windows 2000: 3.23.47-nt
> Linux 7.2: 3.23.49-max-log
>Also happens on Linux with InnoDB instead of MyISAM.