ght_col < p.right_col
AND m.id IS NULL AND p.id = 1;
SELECT will not work but print error:
Can't reopen table: 'c'
>Fix:
No idea
>Submitter-Id: ilya
>Originator:Ilya Martynov
>Organization:
>
>MySQL support: none
>Synopsis: Query doesn't w
[EMAIL PROTECTED] writes:
> >Description:
>
> Query doesn't work on temprory table while works on normal tables.
>
>
Hi!
This is documented in our manual.
Aliasing of temporary tables will be enabled in MySQL 4.0.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. S