codice:
select t1.teamname as sq1,t2.teamname as sq2,c.homescore as gsq1,c.visitorscore as gsq2
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
order by c.uid
Fai riferimento agli alias per estrapolare i dati.