var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sum Question
I need help with the sum function. I have this query which works just the way I want:
However I would like to do this for all the companies and accounts at the same time rather than needed to write one by one, is this possible?
SELECT SUM (SPLIT) FROM CC_SPLIT WHERE COMPANY = 'XXX' AND ACCOUNT ='YYY'
Thanks in advance
Last edited by buzmay; 02-01-12 at 09:47.
select company, account, sum(split)
group by company, account
Thanks a lot