select dat1 as datum, f2, f3, ...
from file1
where ...
union all
select dat2 as datum, f2, f3, ...
from file2
where ...
union all
select dat3 as datum, f2, f3, ...
from file3
where ...
order by datum