表之間的關(guān)系為：

manager 1-------------->n department 1----------------->n employee

mysql> select * from manager;

2 rows in set (0.00 sec)

mysql> select * from department;

3 rows in set (0.00 sec)

mysql> select * from employee;

2 rows in set (0.00 sec)

mysql> select * from manager as ma inner join department as de on ma.id=de.manag
er_id inner join employee as em on de.id=department_id;

2 rows in set (0.02 sec)

三張表的連接可理解為這樣：
mysql> select * from manager as ma inner join department as de on ma.id=de.manag
er_id;

先讓manager和department兩張表做內(nèi)連接，結(jié)果如上

然后再用這張表與employee做內(nèi)連接。結(jié)果如下

mysql> select * from manager as ma inner join department as de on ma.id=de.manag
er_id inner join employee as em on de.id=department_id;

總結(jié)

以上是生活随笔為你收集整理的三表连接之内连接的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。