Ordinamento inner o union

[RoTeam]

Prova cosi allora

SELECT * FROM tabella1 INNER JOIN tabella2 ON tabella1.time = tabella2.time