joined-курсор был использован в другом операторе SELECT

[raz]

С Рождеством всех!!

Я не пойму, почему возникает ошибка.

PHP код:

static void Job1(Args _args)
{
    SalesLine                   SalesLine;
    SalesTable                  SalesTable;
    InventTable                 InventTable;
    InventJournalTrans          InventJournalTrans;
    InventDim                   InventDim;
    ;
    while select SalesLine
          join   SalesTable
          join   InventTable
          join   InventDim
                       where SalesTable.SalesId                 == SalesLine.SalesId         &&
                             InventTable.ItemId                 == SalesLine.ItemId          &&
                             InventDim.InventDimId              == SalesLine.inventDimId
    {
    }

    while select sum(Qty),sum(CostPrice) from InventJournalTrans
                 group by TransDate,ItemId,InventDimId
          join   InventDim
                 group by InventDimId, InventSizeId, InventBatchId, ConfigId, InventLocationId
          join   InventTable
                 group by ItemId, ItemGroupId, ItemName
                            where InventJournalTrans.JournalType           == InventJournalType::Movement    &&
                                  InventTable.ItemId                       == InventJournalTrans.ItemId      &&
                                  InventDim.InventDimId                    == InventJournalTrans.inventDimId
    {
    }
}