B
balu
dear brothers / sisters.
im looking for the query like this for my accounting database
exactly my need is like an bank account deposits
in which deposits will be individual(groupby) ,but the sum of the deposits
will be like the (groupby) of progrssive sum of deposits .
for eg,
TABLE 1
account holder
account
address
TABLE 2
accountnumber
deposit
withdrawl
query:
groupby(accountnumber,accountholder,deposit,withdrawl),progressivesum(groupby(deposit)),progressivesum(groupby(withdrawl)),and finally accountbalence.
sorry for im not being clear.
it looks like [deposit] 100 ,200,300
[withdrawl] 50,0,0
[progressivesum deposit] 100 ,300 , 600
[progressvesum withdrawl] 50,50,50
kindly help
withregards.
im looking for the query like this for my accounting database
exactly my need is like an bank account deposits
in which deposits will be individual(groupby) ,but the sum of the deposits
will be like the (groupby) of progrssive sum of deposits .
for eg,
TABLE 1
account holder
account
address
TABLE 2
accountnumber
deposit
withdrawl
query:
groupby(accountnumber,accountholder,deposit,withdrawl),progressivesum(groupby(deposit)),progressivesum(groupby(withdrawl)),and finally accountbalence.
sorry for im not being clear.
it looks like [deposit] 100 ,200,300
[withdrawl] 50,0,0
[progressivesum deposit] 100 ,300 , 600
[progressvesum withdrawl] 50,50,50
kindly help
withregards.