PRODROUTE - WTRKCTRID -IN SQL QUERY

Finance and Operations/AX Developer Forum
3

Dear Martin,

Thanks for your valuable input always.

The problem in my Query Prodroute table Routeoprrefrecid values are empty for few Production orders. Please refer the attached below screenshot for your reference.

My Join is broken at routeropr, is there any way to pull the wrkctrid without using routeopr Table in Sql .

Below My Query works fine where routeoprrefrecid is not blank in prodroute table.

Prodroute-wrkctrid.png
Prodroute-wrkctrid.png1123×591 31.5 KB

Thanks

Raj