SELECT ID,System FROM WageTaxTable
WHERE TableType = :TableType AND
ValidFrom$DATE = (SELECT MAX(ValidFrom$DATE)
FROM WageTaxTable
WHERE (ValidFrom$DATE <= :TestDate) and (TableType = :TableType))Generated by ABRA Software a.s. 27.10.2021 16:34:36