ValidTimeState in child table relation in AX 2012 / D365

Hi,

while select validTimeState(AsOnToday) * from hcmEmployment join hcmWorker
where  hcmWorker.RecId == hcmEmployment .Worker &&
hcmWorker.PersonnelNumber == “1269”
{
print hcmEmployment .ValidFrom;
}
pause;
}

Regards