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

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