Třídová akce

Kód:

18

Tělo:

SELECT
  WR.ID
FROM
  WorkingRelations WR
  LEFT JOIN Employees E ON (E.ID = WR.Employee_ID)
  LEFT JOIN Persons P ON (P.ID = E.Person_ID)
  LEFT JOIN RetirementReportCodes RRC ON (RRC.ID = WR.RetReportCode_ID)
WHERE
  P.BirthNumber = :BirthNr AND RRC.Code = :TypeOfActivity
ORDER BY WR.DateOfBegin$Date DESC  

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