Announcements
No record found.
how can i select multi column from table & table rafrenced as ansi
*This post is locked for comments
If you don't specify individual columns, all columns are returned (if it's not an exist/notexist join, of course). If you want just some columns, do it this way:
(...) join Field1, Field2 from myTable (...)
The complete syntax is documented at MSDN.
What do you mean by "table rafrenced as ansi"?
thank you for your post ;
when i select from table1&table2 using join in ansi
select table1.column,table2.column from table1 join table2 on table1.cc=table2.cc
how can i do this in ax ?
fields names in join Claus is not possible in dynamics ax, if in query two tables are joined, all fields will be available for example if want to get customer Account number with Customer i have to take join between customer table and DirPartyTable like below
CustTable custtable;
DirPartyTable dptable,custparty;
while SELECT *
FROM custtable
join custparty
where custparty.RecId==custtable.Party
{
info(custtable.AccountNum +' '+ custparty.Name);
}
Your query:
translated to X++:
Table1 table1; Table2 table ; select column from table1 join column from table2 where table2.cc=table1.cc;
You can use field lists with joins, don't worry.
If you don't know basics, it's absolutely essential to familiarize yourself with the documentation - it's all there. And you can find many examples in the standard AX codebase.
Martin, You are right, I missed the syntax for column names with joins, its working perfectly write. It will really helpful for me too. I am also in learning process.
while SELECT
AccountNum from custtable
join Name from custparty
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
