CODEWITHSUNDEEP
mysql
Sean Konig
Sean Konig

Reputation: 134

Join two columns from one table to one column from another

I am trying to use my home_team and away_team fixture_id's to get their name values from a different table.

This works to get the name value of home_team 

SELECT * FROM fixtures JOIN teams ON fixtures.home_teamID = teams.TeamID

To get the name value of the away team I have the following

SELECT * FROM fixtures JOIN teams ON fixtures.home_teamID = teams.TeamID 
JOIN teams ON fixtures.away_teamID = teams.TeamID

But this then returns a boolean

Upvotes: 0

Views: 37

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133360

you should join the teams table two time using two different alias 

  SELECT fixtures.* a.* , b.*
  FROM fixtures 
  JOIN teams a ON fixtures.home_teamID = a.TeamID
  JOIN teams b ON fixtures.home_teamID = b.TeamID

Upvotes: 1

Related Questions