Hi
I have a transaction table that contains
LedgerName DebitOrCredit DebitAmount CreditAmount VoucherNo
Cash A/c Dr 3000.00 0.00 1
Cash A/c Dr 3000.00 0.00 2
Axis Bank A/c Cr 0.00 3000.00 2
Cash A/c Dr 700.00 0.00 6
Orders A/c Cr 0.00 700.00 6
Cash A/c Dr 700.00 0.00 18
Orders A/c Cr 0.00 700.00 18
Cash A/c Dr 700.00 0.00 54
Orders A/c Cr 0.00 700.00 54
Cash A/c Dr 700.00 0.00 7
Orders A/c Cr 0.00 700.00 7
If I query for Cash A/c, my result would be
Axis Bank A/c Cr 3000.00
Orders A/c Cr 700.00
Orders A/c Cr 700.00
Orders A/c Cr 700.00
Orders A/c Cr 700.00
Please provide me the sql query.