Třídová akce

Kód:

3

Tělo:

  SELECT MC.* FROM PLMMACHINECOMPETENCES MC
  JOIN PLMMACHINES M ON M.id = MC.PARENT_ID AND M.MachineKind = :MachineKind
  JOIN PLMWORKPLACESMACHINES WM ON WM.MACHINE_ID= M.ID AND WM.Parent_ID = :WorkPlace_ID
  WHERE 
   MC.Competence_ID = :Competence_ID

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