Запрос

[DreamCreator]

Доброго утра!

PHP код:

        /* ++ Журнал платежей */

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

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


В чем ошибка?