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 USING
[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] wrote:
I tried:
select ... from T1 a inner join T1 b using(...);
and it doesn't work. I get a message
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:
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?