Simple SQL help

[Riz 0]

Hi all,

I have got table Trns like below, How can write SQL to find the balance?

date------desc---Credit---Debit---Balance

12/9------any 0.00 5.00 -500

13/9------any 3.00 0.00 -200

14/9------any 2.30 0.00 30

Thanks in advance.

Edited September 13, 2006 by Riz

[Riz 0]

Hi all,

I have got table Trns like below, How can write SQL to find the balance?

date------desc---Credit---Debit---Balance

12/9------any 0.00 5.00 -500

13/9------any 3.00 0.00 -200

14/9------any 2.30 0.00 30

Thanks in advance.

Any help please. its urgent

Edited September 13, 2006 by Riz