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

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_6_12_2005