select StoreCards.Name, cast(documents.OrdNumber as integer),
ib_datetostring(documents.DocDate$Date,'DD.MM.YYYY '),
documents2.QUnit, documents2.ID, storeBatches.Name, StoreCards.EAN,
LogStorePositions.BarCode, StoreCards.id StoreCardId, StoreCards.Code KodSklKarty,
(select l1.storeposition_id PoziceOdkud, l2.storeposition_id PoziceKam, SC.name from logstoredocuments ld
left join logstoredocuments2 l1 on l1.parent_id=ld.id and ld.documenttype='33'
left join logstoredocuments2 l2 on l2.id=l1.masterrow_id left join storecards SC on sc.id=l1.storecard_id
where l2.storeposition_id is not null and l2.Parent_ID = '' ) from LogStoreDocuments documents left join LogStoreDocuments2 documents2 ON Documents.id=documents2.Parent_ID left join StoreCards
ON Documents2.StoreCard_ID=StoreCards.id LEFT JOIN storeBatches on documents2.StoreBatch_ID = storeBatches.ID LEFT JOIN
LogStorePositions ON LogStorePositions.ID = documents2.StorePosition_ID where Executed = 'N' and DocumentType = '33' and
documents.OrdNumber = '&A2' and PositionType = '0' order by LogStorePositions.BarCode


Hlásí:

Count of column list and variable list do not match.

Kde se tak děje prosím ?