min Pflugmann" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 8:01 AM
Subject: Re: Joining table with itself
> Hi.
>
> On Sun, Nov 25, 2001 at 11:32:15PM +0800, [EMAIL PROTECTED] wrot
Hi.
On Sun, Nov 25, 2001 at 11:32:15PM +0800, [EMAIL PROTECTED] wrote:
> I tried:
>
> select ... from T1 a inner join T1 b using(...);
>
> and it doesn't work. I get a message about "Can't reopen table: 'a' ".
I cannot reproduce this:
mysql> SELECT count(*) FROM config a INNER JOIN config b U
