- 多个JOIN从左到右执行
select * from a left join b on a.id=b.id left join c on b.id=c.id
先a和b交的结果集t,t再和c相交
mysql> select * from a;
+------+------+
| id | name |
+------+------+
| 1 | a1 |
| 2 | a2 |
| 3 | a3 |
| 4 | a4 |
+------+------+
4 rows in set (0.00 sec)
mysql> select * from b;
+------+------+
| id | name |
+------+------+
| 1 | b1 |
| 2 | b2 |
| 5 | b5 |
+------+------+
3 rows in set (0.00 sec)
mysql> select * from c;
+------+------+
| id | name |
+------+------+
| 1 | c1 |
| 4 | c4 |
| 5 | c5 |
+------+------+
3 rows in set (0.00 sec)
mysql> select * from a left join b on a.id=b.id;
+------+------+------+------+
| id | name | id | name |
+------+