Třídová akce

Kód:

32

Tělo:

SELECT 
  A.ID 
FROM 
  SickBenefits A
  LEFT JOIN WorkingRelations WR ON (WR.ID = A.WorkingRelation_ID)
  LEFT JOIN Employees E ON (E.ID = WR.Employee_ID)
  LEFT JOIN Persons P ON (P.ID = E.Person_ID)
WHERE
  P.BirthNumber = :BirthNr AND A.DecisionNumber = :DecisionNr

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