http://blogs.msdn.com/b/x/archive/2008/12/19/using-the-cross-company-feature-from-the-business-connector-and-table-browser.aspxIn Ax 2009 the new cross company feature was introduced. It allows the programmer to specify a container containing strings denoting company names to the crosscompany hint: container c = ['dat', 'dmo']; select crosscompany: c * from custtable whereen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/x/archive/2008/12/19/using-the-cross-company-feature-from-the-business-connector-and-table-browser.aspx#9251750Wed, 24 Dec 2008 16:06:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:9251750wenni057<p>Hi Peter,</p> <p>is it posible to make join with the ExecuteStm,</p> <p>I tried this &quot;SalesTable st; select * from %1 join st where %1.accountnum == st.custaccount&quot; but it did not work out.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9251750" width="1" height="1">