Запрос

[Ace of Database]

Попробуйте так:

PHP код:

                select  count(RecId),           // Количество записей
                        sum(AmountCurDebit),    // Дебит
                        sum(AmountCurCredit)    // Кредит
                from ledgerJournalTrans
                    where
                        ledgerJournalTrans.DocumentDate  == infoAboutShop.shCreatedDate      &&  // Даты
                        ledgerJournalTrans.OffsetAccount == cashDepartment.RCashAccount          // Кассы


                join
                    ledgerJournalTable
                group by JournalNum
                    where
                        ledgerJournalTable.JournalNum    == ledgerJournalTrans.JournalNum    &&  // Связь по коду журнала
                        ledgerJournalTable.Posted        == NoYes::Yes                       &&  // Разнесено
                        ledgerJournalTable.JournalType   == LedgerJournalType::CustPayment;      //Тип журнала: клиентский платеж------------------------