Třídová akce

Kód:

19

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)
WHERE
 (WR.DateOfBegin$DATE < 39814) and
 (P.BirthNumber = :BirthNr) and 
 (WR.TypeOfActivity = :TypeOfActivity)
ORDER BY WR.DateOfBegin$Date DESC 

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