Hi all,
I found this join problem using mysql 3.23.53-max-nt (on WinXP). It works fine on MySQL 3.23.52-log (on Linux). Could someone please confirm that it is a bug? Or enlighten me on writing the correct sql? I have a table and data as shown in the script below. CREATE TABLE test ( f1 int(11) NOT NULL default '0', f2 int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Dumping data for table `test` # INSERT INTO test VALUES (1, 2); INSERT INTO test VALUES (1, 4); Then I do a join with this query: SELECT t1.*, t2.* from test as t1, test as t2 where t1.f1 = t2.f1 Unfortuantley, I got this output. f1 f2 f1 f2 1 2 1 2 1 2 1 2 1 4 1 4 1 4 1 4 I would expect the output like this (which I get on Linux using MySQL 3.23.52-log). I also get this using other DB (e.g. Access). f1 f2 f1 f2 1 2 1 2 1 4 1 2 1 2 1 4 1 4 1 4 Does anyone else experience the same problem? Thanks. Haksun