T>на order by ругается.

select * from
(
  select f1, f2 from table1
  union all
  select f1, f2 from table2
)
order by f1