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
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
SELECT LedgerName, DebitOrCredit, CreditAmount FROM [YourTable] WHERE VoucherNo IN ( SELECT VoucherNo FROM [YourTable] WHERE LedgerName = 'Cash A/c' ) AND DebitOrCredit = 'Cr'
select LedgerName,DebitOrCredit,CreditAmount from table_name where DebitOrCredit='Cr'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)