title: How to join AX tables using .net interop?
body: <p>I am trying to create a utility for AX 2012 in visual studio using .net interop to X++ and proxy classes, I've added necessary tables in my project, I can access tables individually and can loop them through .next() method, but I want to join these tables so I can get my desired results (I want to display a grid with item id, name alias, color, size information).</p>
  
  <p>I am unable to figure out how to join <code>InventTable</code>, <code>InventDim and</code>InventDimCombination` for this purpose. Can you guys please tell me how can I join AOT tables without having to use traditional .net business connector methods in visual studio?</p>