i have a question i want to display bank statement which shows balance,amount(total) for an account after every transaction how should i do it ?? rite now i am using inner join and what i am getting is balance(initial) amount(intial+current transaction) what i require is balance(updated) amount (updated+current transaction) same like how a bak give us balance sheet