SELECT A.ID as ID, B.ID as UnitID, B.Code as UnitCode FROM StoreCards A, StoreUnits B WHERE (Upper(A.Name collate pxw_csy) = :CodeName) and (A.Hidden = 'N') and (B.Parent_ID = A.ID) and (b.code = a.MainUnitCode)
Generated by ABRA Software a.s. 27.10.2021 16:34:11