mysql - 内部联接选择多个 id 作为名称

Question

我真的卡住了，我有 2 个包含足球比赛数据的表格:

团队

id, name

夹具

id, hometeam, awayteam

我做了以下事情:

SELECT hometeam, awayteam, score, week FROM fixture
join team on fixture.hometeam = team.id;

基本上主队和客队是与球队表相关的 ID 号，但我需要将它们输出为实际的文本名称。

任何帮助将不胜感激

谢谢:)

Answer 1

SELECT  th.name AS hometeam_name, ta.name AS awayteam_name, week, score
FROM    fixture
JOIN    team th
ON      th.id = fixture.hometeam
JOIN    team ta
ON      ta.id = fixture.awayteam