This is an example how to use joined tables:
Axapta ax = new Axapta(); ax.Logon(null, null, null, null); using (AxaptaRecord users = ax.CreateAxaptaRecord("UserInfo"), groups = ax.CreateAxaptaRecord("UserGroupList")) { ax.ExecuteStmt("select * from %1 join %2 where %1.id == %2.userId", users, groups); while (users.Found) { Console.WriteLine("{0} ({1})", users.get_Field("id"), groups.get_Field("groupId")); users.Next(); } }