Re: Subquery strangeness when used in FROM clause

"Andrew Braithwaite" <[EMAIL PROTECTED]> wrote on 12/06/2005 11:34:50 AM: > Hi, > > I'm having a problem with subqueries in MySQL 4.1.14 running on Fedore > core 3. > > mysql> create table day_6_12_2005 (f1 int(1), f2 char(4)); > Query OK, 0 rows affected (0.04 sec) > > mysql> insert into day_

Subquery strangeness when used in FROM clause

Hi, I'm having a problem with subqueries in MySQL 4.1.14 running on Fedore core 3. mysql> create table day_6_12_2005 (f1 int(1), f2 char(4)); Query OK, 0 rows affected (0.04 sec) mysql> insert into day_6_12_2005 values(1,'test'); Query OK, 1 row affected (0.00 sec) mysql> select * from (select