SELECT {FIELDS} FROM FirmPersons A
LEFT JOIN Persons P on A.Person_ID = P.ID
LEFT JOIN FirmOffices FO on A.FirmOffice_ID = FO.ID
LEFT JOIN CommonWorkPositions CWP on A.CommonWorkPosition_ID = CWP.ID
WHERE A.Parent_ID = :OBJIDGenerated by ABRA Software a.s. 27.10.2021 16:34:09