Программно получить обороты по счету

[sukhanchik]

    LedgerTrans ledgerTransDebit, ledgerTransCredit;
    ;
    while select AccountNum, AmountCur, TransDate from ledgerTransDebit
        where ledgerTransDebit.Crediting == NoYes::No
        join AccountNum, AmountCur, TransDate from ledgerTransCredit
        where ledgerTransCredit.BondBatch_RU      == ledgerTransDebit.BondBatch_RU      &&
              ledgerTransCredit.BondBatchTrans_RU == ledgerTransDebit.BondBatchTrans_RU &&
              ledgerTransCredit.Crediting         == NoYes::Yes
    {
    ....
    }