Nebo ještě jednou a lépe, kde je chyba:


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, l1.storeposition_id PoziceOdkud, l2.storeposition_id PoziceKam
from LogStoreDocuments documents left join LogStoreDocuments2 l1 ON Documents.id=l1.Parent_ID left join StoreCards
ON l1.StoreCard_ID=StoreCards.id LEFT JOIN storeBatches on l1.StoreBatch_ID = storeBatches.ID LEFT JOIN
LogStorePositions ON LogStorePositions.ID = l1.StorePosition_ID
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 on storecards.id=l1.storecard_id
where Executed = 'N' and DocumentType = '33' and
documents.OrdNumber = '2190' and PositionType = '0' order by LogStorePositions.BarCode