The first statement rounds to two decimal places, if I
remove the sum ( after the union)
(second statement) NO rounding occurs. Anyone know of a
way to keep it from rounding and still sum the number?
SELECT sum((calls.rated_toll_cost +
FROM (calls join cost_groups on cost_group_nbr =
call_cost_group and report_group = 'all') join
organization on organization.organization =
WHERE switch_ext = '508' and site = 'BOS' and
call_cost_group = '16' and
calls.organization is not null
WHERE switch_ext = '508' and site = 'BOS' and pin = ''