Objektová akce

Kód:

2

Tělo:

SELECT (PER.FirstName || ' ' || PER.LastName || ' ' || PAT.Code || ' ' || A.CalendarYear) AS DISPLAYNAME
FROM
  RetirementReports A
  JOIN WorkingRelations WR on WR.ID = A.WorkingRelation_ID
  JOIN Employees EMP on EMP.ID = WR.Employee_ID
  JOIN Persons PER on PER.ID = EMP.Person_ID
  JOIN EmployPatterns PAT on PAT.ID = WR.EmployPattern_ID 
where
  A.ID = :OBJID  

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