将OMOperatingUnit表链接到AX 2012中的CompanyInfo

我的第一个表临时返回结果 companyInfo 以及第二表临时返回结果 omoeratingUnit 所以我想链接这两个表,但我不知道如何才能做到这一点。为此,我尝试测试这个查询,但它返回0条记录。

SELECT * 
FROM DIRPARTYTABLE Party
    INNER JOIN MicrosoftDynamicsAx.dbo.DIRPARTYTABLE Common
        ON  Common.RECID = Party.RECID
        AND Common.INSTANCERELATIONTYPE = 2376

    LEFT OUTER JOIN MicrosoftDynamicsAx.dbo.DIRPARTYTABLE  OMOPerating 
        ON  OMOPerating.RECID   = Common.RECID
        AND OMOPerating.INSTANCERELATIONTYPE = 2377
        AND OMOPerating.RECID   = Party.RECID

    LEFT OUTER JOIN MicrosoftDynamicsAx.dbo.DIRPARTYTABLE CompanyInfo 
        ON   CompanyInfo.RECID = Common.RECID
        AND  CompanyInfo.INSTANCERELATIONTYPE = 41
        AND  CompanyInfo.RECID  = Party.RECID
        AND  CompanyInfo.DATAAREA = 'USMF'

那么 CompanyInfo Table and OMOperatingUnit Table

这方面的任何身体帮助。