[Axapta-Knowledge-Village] Join two table in COM Connector

[joelwu]

Dear all:     What I can do to join two table when using COM Connector ?   I try the following but can’t get and record.               AxaptaCOMConnector.IAxaptaRecord AxGetPriceTable;             try             {                 AdminLogin();   //some function to login to Axapta                 AxGetPriceTable = Axapta.CreateRecord("InventTableModule");                 AxGetPriceTable.ExecuteStmt("SELECT InventTableModule Join InventTable Where InventTable.ItemID == InventTableModule.ItemID && InventTable.ItemID == 'BON-F-52TFB-100'");                 while (AxGetPriceTable.Found)                 {                     //Do something to exactly the record out… }             catch(Exception err)             {                 MessageBox(err.Message);                                 }                                             The above code didn’t throw any exception, only return false in AxGetPriceTable.Found, so anyone know how to join two table? Regards, Joel   Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.