Třídová akce

Kód:

4

Tělo:

select SB.ID, SB.ValidTo$DATE, SB.Code
from SickbenefitTypes SB
join wageperiods WP on WP.ID = :WagePeriod_ID
where
  ((SB.ValidTo$DATE >= WP.DateFrom$DATE) or (SB.ValidTo$DATE = 0))  and
  (SB.Preferred = 'A')
order by
  SB.ValidTo$DATE

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