select PersonnelNumber,Recid from hcmWorker
where hcmWorker.PersonnelNumber == '000006'
join Position,worker from hcmPositionWorkerAssignment
where hcmPositionWorkerAssignment.Worker == hcmWorker.Recid
join PositionId,RecId from hcmPosition
where hcmPosition.RecId == hcmPositionWorkerAssignment.Position;
info(strFmt("%1,%2",hcmWorker.PersonnelNumber,hcmPosition.PositionId));
where hcmWorker.PersonnelNumber == '000006'
join Position,worker from hcmPositionWorkerAssignment
where hcmPositionWorkerAssignment.Worker == hcmWorker.Recid
join PositionId,RecId from hcmPosition
where hcmPosition.RecId == hcmPositionWorkerAssignment.Position;
info(strFmt("%1,%2",hcmWorker.PersonnelNumber,hcmPosition.PositionId));