Table structure for Balance table-

Required result from the query -

Like in a Bank's money transaction output, the RunningBalance column is needed which displays the balance an account holds against that will account transaction.

Query to achieve it -

Explanation -

The result is achieved by a self join of the Balances table. The first table b1 returns the complete table output, inner join has two conditions. The first condition 'b1.DateStamp >= b2.DateStamp' is the most important which gives the result for SUM(b2.Amount). The last two records for BalanceID 4 and 6 have the exact same DateStamp hence without the second condition 'b1.BalanceID >= b2.BalanceID' will give same result for the RunningBalance column.