Třídová akce

Kód:

5

Tělo:

SELECT B.StringFieldValue, A.FieldDataType
 FROM WageConstantValues B
  JOIN WageConstants A ON B.Parent_ID=A.ID
 WHERE A.Code=:Code AND B.ValidFrom$DATE =
  (SELECT MAX(B.ValidFrom$DATE)
   FROM WageConstantValues B
   WHERE B.Parent_ID=A.ID AND B.ValidFrom$DATE<=:ValidDate)

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