i have a table
field are
acc_code,acc_desc, debit, credit
i want result lik
acc_desc,debit,credit, balance
AC_DESC,200,0, 200
AC_DESC,0 100, 100
kingdly anyone give me sql query?
what will be query?
What I have tried:
select acc_desc, debit, credit , debit-credit balance
where acc_code = 1001