Diferenciar campos con mismo nombre en inner join

[juanito1712]

select * from matches
inner join teams as t1 on matches.localTeam=t1.id
inner join teams as t2 on matches.visitingTeam=t2.id
inner join reservations as r on matches.id=r.refered

¿Como diferencio el id de t1 de el id de t2 por ejemplo?

[Libras]

seleccionando las columnas en el select y usando alias:

Código SQL:

SELECT t1.id AS id_1, t2.id AS id_2, t3.id AS id_3  FROM matches
INNER JOIN teams AS t1 ON matches.localTeam=t1.id
INNER JOIN teams AS t2 ON matches.visitingTeam=t2.id
INNER JOIN reservations AS r ON matches.id=r.refered