Announcements
Data entity have only two options to join data sources (inner and outer join). and other two ( exist and not exist) need to firstly convert data source to data entity view and apply these join. How can I use left outer join in data entity ?
Hi,
There is no left outer join in dynamics Ax - You can use Outer join for the data entities which works similar.
Thanks,
Girish S.
Hi, In SQL we have concept of Left outer join and Right outer join as specified below. However, in Ax we don't have Right Outer Join, its only Outer join which is left outer join.
Left Outer Join: Returns all the rows from the LEFT table and matching records between both the tables.
Right Outer Join: Returns all the rows from the RIGHT table and matching records between both the tables.
community.dynamics.com/.../left-outer-join-in-ax-2012
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 676
Abhilash Warrier 635 Super User 2026 Season 1
André Arnaud de Cal... 605 Super User 2026 Season 1