title: linking OMOperatingUnit table to CompanyInfo in AX 2012
body: <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>