select f1, f2, f3, f4 from datei where ...
union all
select f1, f5, f6, f7 from datei where ...
union all
select ...

order by 1