mysql - MySQL中如何连接三个表

Question

select a.CHAR_DATE, a.CHAR_DESTINATION, a.AC_NUMBER, c.MOD_NAME, c.MOD_CHG_MILE
from CHARTER a JOIN AIRCRAFT b
on a.AC_NUMBER = b.AC_NUMBER
AND MODEL c JOIN AIRCRAFT
on c.MOD_CODE = a.MODE_CODE

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c JOIN AIRCRAFT on c.MOD_CODE = a.MODE_CODE' at line 4

我在连接三个表时遇到语法错误，其中 A - B - C(A 与 B 具有公共(public)列，B 与 C 具有公共(public)列)。我做错了什么？

Answer 1

这是正确的方法:

CHARTER a JOIN AIRCRAFT b on a.AC_NUMBER = b.AC_NUMBER
JOIN MODEL c on c.MOD_CODE = a.MODE_CODE

不需要 AND - 您只需将另一个表与之前的两个表连接在一起即可。