query mysql per estrarre classifica da db calcistico

[nicola75ss]

select t1.teamname,t2.teamname,c.homescore,c.visitorscore
from ca5_calendar as c
inner join ca5_teams as t1 on t1.uid = c.hometeam 
inner join ca5_teams as t2 on t2.uid = c.visitorteam