Attempting to create a SQL query between Scheduled and Worker

Finance and Operations/AX Developer Forum
1

Within [Entity] > Enterprise asset management > Common > Work Order > All Work Orders

We have a field in the list box called Schedule. This information is pulled from:

MROWorkOrderTable_WorkerScheduled_HcmWorker_DirPerson_FK_Name
DirPartyTable

I am creating a query from the Work Order table (MROWORKORDERTABLE) and I am trying to retrieve this value. I have attempted to join MROWORKORDERTABLE.WORKERSCHEDULED to fields within DIRPARTYTABLE, DIRPERSONUSER and DIRPERSONNAME. I am unable to find the relevant join.

Please can somebody help me.

2

Look at the relations on the table (MROWORKORDERTABLE). It might be having a relation with worker.
MROWORKORDERTABLE.WORKERSCHEDULE == HCMWorker.RecId.