你可以创建视图后加入它是为了让你的工作更简单，为进一步的发展，我改进了福巴斯先生代码如下

CREATE VIEW team AS select 
m.m_id, 
t1.t_name as team_a, 
t2.t_name as team_b, 
m.m_time
 from 
matches m inner join teams as t1 on m.team_a=t1.t_id
inner join teams as t2 on m.team_b=t2.t_id
 order by m.m_id;

你需要加入两列 matches 到 teams 表格：

select 
  m.m_id, 
  t1.t_name as team_a, 
  t2.t_name as team_b, 
  m.m_time
from 
  matches m inner join teams as t1 on m.team_a=t1.t_id
  inner join teams as t2 on m.team_b=t2.t_id
order by m.m_id;

需要从表匹配到表组的两个内部联接，如：

SELECT
    ta.t_name,
    tb.t_name
FROM
    matches m
    INNER JOIN team as ta on ta.t_id = matches.team_a
    INNER JOIN team as tb on tb.t_id = matches.team_b

首先，不要在句子中使用逗号 FROM 条款。始终使用适当的、明确的、标准的 JOIN 语法。你需要两个 JOIN 事实上：

select m.*, ta.t_name as name_a, tb.t_name as name_b 
from matches m left join
     teams ta
     on m.team_a = ta.t_id left join
     teams tb
     on m.team_b = tb.t_id;

它使用 left join 只是为了确保你得到所有的比赛，即使其中一支球队失踪。在这种情况下，这可能不是一个重要的考虑因素，所以 inner join 就相当于。