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
If you want to use your table more than once you have to declare that.
select ... from T1 as FirstT1, T2 as SecondT1 where
FirstT1.column...=SecondT1.column...;
Eva Fransson
-
Before posting, please check:
http://www.mysql
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' ".
Is this not something that belongs in section "1.4.4 Functionality
Missing from MySQL" of the manual?
-
