mysql - 将表连接成 4 列

Question

我在显示不同表中的 4 个不同列时遇到问题，有关更多详细信息，请参阅下面的内容:

个人表(tbl_personal)

+---+-----+------------+
|ID |Name |Skill       |
+---+-----+------------+
| 1 | Nia | Accountant |
| 2 | Tia | Banking    |
| 3 | Ria | Technicall |
| 4 | Dia | Admin      |
+---+-----+------------+

表主控(tbl_master)

+---+---------+---------+
|ID |Employee1|Employee2|
+---+---------+---------+
| 1 | 1       | 2       |
| 2 | 2       | 1       |
| 3 | 3       | 4       |
+---+---------+---------+

我想在 codeigniter 中显示上面 tbl_master 的网页，如下所示:

+---+-------+-----------+-------+-----------+
|ID |Name 1 |Skill 1    |Name 2 |Skill 2    |
+---+-------+-----------+-------+-----------+
| 1 | Nia   | Accountant| Tia   | Banking   |
| 2 | Tia   | Banking   | Nia   | Accountant|
| 3 | Ria   | Technicall| Dia   | Admin     |
+---+---------+---------+-------+-----------+

如果有任何建议我从 tbl_personal 加入 tbl_master，请提出建议，

感谢您的支持...

Answer 1

您需要加入两次个人 table 。像下面这样

select tp1.name name1,tp1.skill skill1,tp2.name name2,tp2.skill skill2 
from tbl_master tm
join tbl_personal tp1
on tm.Employee1 =tp1.ID
join tbl_personal tp2
on tm.Employee2 =tp2.ID