select Parent_ID, EuMember from Countries2 A where (A.DateOfChange$Date = (select MAX(DateOfChange$Date) from Countries2 where Parent_ID = A.Parent_ID and DateOfChange$Date <= :DateOfChange$Date))
Generated by ABRA Software a.s. 27.10.2021 16:34:08