linking OMOperatingUnit table to CompanyInfo in AX 2012
<p>My first table temporary return result of <code>companyInfo</code> and the second table temporary return result of <code>omoeratingUnit</code>
So i want to link the both table but i don't Know how can i do that .So for that i"m trying to test this query  but it return 0 record.</p>

<pre><code>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'
</code></pre>

<p>SO is there a relation between <code>CompanyInfo Table and OMOperatingUnit Table</code></p>

<p>Any body help in this regards.</p>