I have a table that stores transactions for income and expenditure. the fields of the table is shown below transid, accountcredited, accountdebited, date, amount. Every transaction has double entry; it debits one account and credit another. The accountcredited and accountdebited are linked to accounts table(the fields for accounts table are accid, accountno, balance) The problem is I cannot figure out sql statement generate running balance Thanks in advance