Mysql two join on one table

Vote count: 0

I have 2 tables: matches, teams

In table matches I have home_id and away_id I need to get 2 times the name of teams which are in table teams, but how?

I try this: Select * from matches as m Inner join teams as t On m.home_id=t.team_id Inner join teams as ta On m.away_id But in php (browser) isnt two teams, display only away team

... Also in phpmyadmin I get all what i need, how can get it into my app? :)

asked 41 secs ago

Albert Francis

Let's block ads! (Why?)

Mysql two join on one table