I would like to sum a sum from a query. That is the code:
Code:
SELECT distinct ps.v_sbkuerzel as Worker , sl.v_bezeichnung as Activities, sum ( m.n_betr_ho) as sum from mbu_bks m,stamm_lookup sl,akte_akte a,pers_sbkonto ps where m.c_sh = 'H' and a.i_mana_lookup_id = sl.i_stamm_lookup_id and a.i_akte_akte_id = m.i_akte_akte_id and m.n_betr_ho > 0 group by sl.v_bezeichnung,ps.v_sbkuerzel