Třídová akce

Kód:

8

Tělo:

SELECT
 A.WagePeriod_ID, B.FieldCode, B.StringFieldValue
FROM
  WageListPartial A, UserWGData B
WHERE
  (A.ID = B.ID) AND
  (A.WorkingRelation_ID = :WrkRelationID) AND
  (A.WagePeriod_ID IN (SELECT AValue from
    GetPreviousNPeriods(:PeriodID, :CountBack)
  )) AND
  (B.CLSID = :CLSID) AND
  ((B.FieldCode = :FieldCode1) OR (B.FieldCode = :FieldCode2))
ORDER BY
  A.WagePeriod_ID

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