X++:
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
{
....
}