List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 12 2002 5:14pm
Subject:Re: Can't join temp table to self?
View as plain text  
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?


>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.

Can't join temp table to self?Bill Easton12 May
  • Re: Can't join temp table to self?Paul DuBois12 May