select (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' || c.Code) from AssetInv A join DocQueues B on B.ID = A.DocQueue_ID join Periods C on C.ID = A.Period_ID where A.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:24