Select
A.Name as MaxCode,
A.ID as ID,
A.Name as Name,
A.Hidden as Hidden
from
StoreBatches A
where
A.Name = (SELECT MAX(SB.Name)
FROM StoreBatches SB
JOIN StoreCards SC ON SC.ID = SB.StoreCard_ID
WHERE SC.StoreBatchStructure_ID = :CodeStructure_ID AND SB.Name LIKE :Formula)Generated by ABRA Software a.s. 27.10.2021 16:34:11