hello need some help here..
sample i have a query like this
select sum(field1) as f1, sum(field2) as f2 from table group by company
so what i want is to make a third field that will add the value from f1 and f2 what do u think should i do with this?
I would think SUM(field1) AS f1, SUM(field2) AS f2, SUM(field1,field2) AS f3
i tried that 1 but it gives me an error
i already solve it thank you anyway 🙂
generally its good practice to actually post what the solution was so that future searches that turn up this thread can see how it was done and not have to post ANOTHER thread that asks the same question.
I assume it was something like
SELECT field1, field2, field1+field2 as field3 from table
?
