select * from (class1 c1 join class2 c2 on c1.name=c2.name) join class3 c3 on c1.name=c3.name;
实际效果
(root)mytest-3306>>select c1.name c1name, c1.birthday c1birthday,
-> c2.name c2name, c2.birthday c2birthday,
-> c3.name c3name, c3.birthday c3birthday
-> from (class1 c1 join class2 c2 on c1.name=c2.name)
-> join class3 c3 on c1.name=c3.name;
+--------+---------------------+--------+---------------------+--------+---------------------+| c1name | c1birthday | c2name | c2birthday | c3name | c3birthday |
+--------+---------------------+--------+---------------------+--------+---------------------+
| tom | 2000-01-12 00:00:00 | tom | 1997-01-09 00:00:00 | tom | 1998-08-31 00:00:00 |+--------+---------------------+--------+---------------------+--------+---------------------+1 row in set (0.00 sec)