Objektová akce

Kód:

1

Tělo:

SELECT C.PersonalNumber||': '||C.LastName||' '||C.FirstName||' - '||D.Code||': '||D.Name
  FROM WorkingRelations A JOIN Employees B ON A.Employee_ID=B.ID
  JOIN Persons C ON B.Person_ID=C.ID
  JOIN EmployPatterns D ON A.EmployPattern_ID=D.ID
  WHERE A.ID = :OBJID

Generated by ABRA Software a.s. 27.10.2021 16:34:36