select a.str,sum(a.uporiz) as poriz,sum(a.uoprav) as oprav, sum(a.uzusta) as zusta,sum(a.uodpis) as odpis from &soubs a into dbf c7_sumaj group by a.str order by a.str
select a.str,sum(a.poriz) as poriz,sum(a.oprav) as oprav, sum(a.zusta) as zusta,sum(a.odpis) as odpis from &soubs a into dbf c7_sumaj group by a.str order by a.str