select B.Firm_ID from FirmOffices A left join Firms B on B.ID = A.Parent_ID where A.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:09