SQL查询有关加入2选择

Question

我想知道如何加入2个这样的陈述：

Select Team.name from Team join Match on Team.id == Match.teamHomeid
Select Team.name from Team join Match on Team.id == Match.teamAwayid

遇到的错误是因为我没有单独的家庭和外客团队的ID

我

Answer 1

您可以多次使用同一表。 IE：

Select t1.Name as HomeTeam, t2.Name as AwayTeam 
from Match m
inner join Team t1 on t1.Id = m.teamHomeId
inner join Team t2 on t2.Id = m.teamAwayId