mysql> select* from table1;
+------+-------+
| id | name |
+------+-------+
| 1 | lee |
| 2 | zhang |
| 4 | wang |
+------+-------+
3 rows in set (0.00 sec)
mysql> select * from table2;
+------+-------+
| id | score |
+------+-------+
| 1 | 90 |
| 2 | 100 |
| 3 | 70 |
+------+-------+
3 rows in set (0.00 sec)
mysql> select * from table1 full join table2 on table1.id=table2.id;
ERROR 1054 (42S22): Champ 'table1.id' inconnu dans on clause
我都怀疑是不是版本问题，或者full join on 用法 淘汰了呢
