Finance | Project Operations, Human Resources, ...

What is the proper way to add a left outer join relation in a data entity data-source?

(0) Share

Report

Posted on by itlabnarmi_ivoruk

166

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 ?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No