Zusammenfassende Abfrage

[Olli73]

Meinst du sowas?

Code:

select konto, sum(betr) as betrag from
(
select kontozweckA as konto, betragA as betr from tabelle
union all
select kontozweckB as konto, betragB as betr from tabelle
)
group by konto
order by 1