SUM Werte im Union addieren

[mkinzler]

SQL-Code:

select
    sum( ...), ...
from
((select
FLD01, Decimal(sum(FLD02), 7, 2)
from tridatt.oldph
where FLD03 In ('17', '18')
group by FLD01)

union

(select
FLD01, Round(((Decimal(sum(FLD02), 7, 2) / 5) * 3), 0)
from tridatt.oldph
where FLD03 In ('19')
group by FLD01)

order by FLD01 )
group by ...;