|
A
second query, where you let the database to the addition for you might be in
order, unless the select statement is time consuming.
e.g.
SELECT
sum(t1.taxes) AS total_taxes, sum(t1.amount) AS total_amount
FROM
t1
WHERE
...
The
only other possible decent way would be to loop through the query result and add
up the taxes and amount into a local variable. (probably while you are
printing out the table of detail)
Terry Fielder
|
