131
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, 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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (