[Sql] Interrogare due tabelle contemporaneamente

[xegallo]

select t1.peer
     , t1.name
     , t1.rank
  from tabella1 T1
union all
select t2.peer
     , t2.name
     , t2.rank
  from tabella2 T2
order by 3, 2