what is different betwean joins and Exists joins in the D365FO

(0) Share

Report

Posted on by WaytoAx

130

Hi,

i am new in Ax so i wrote small jobs normal joins and Exists joins both output same 10 records shows.

my doubt when to use joins?

when to use Exists joins? also both joins same concept

HCMIqamaDetails iqamaDetails;
HCMIqamaProcess iqamaProcess;

while select firstOnly10 iqamaDetails
join iqamaProcess
where iqamaProcess.RecId == iqamaDetails.IqamaProcessRecId
{

info(strFmt("%1",iqamaDetails.IqamaProcessRecId));

}

HCMIqamaDetails iqamaDetails;
HCMIqamaProcess iqamaProcess;

while select firstOnly10 iqamaDetails
Exists join iqamaProcess
where iqamaProcess.RecId == iqamaDetails.IqamaProcessRecId
{

info(strFmt("%1",iqamaDetails.IqamaProcessRecId));

}

thanks

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

Exist join will not return you the joined table buffer (iqamaprocess)

Normal join will.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (1)

Report

Hi WayToAX,

The main difference between these option is that the normal join will also fetch the columns with all values from the SQL server whereas the exists join will only check if there is a record linked. The exists join will not fetch data from the joined table. The result: performance. If you don't need the field values of the joined table, then it is recommended to use exists join.

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

many thanks quickly replay Nikolaos,

my doubt exist joins not return it is okay, innor join & Exist joins both result same

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

Many thanks Andre Sir.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

You can try to print something from iqamaprocess (the joined table) to your infolog to notice the difference.

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

Info Message (12:47:00 pm) joins : 5637161092

Info Message (12:47:00 pm) exists joins : 5637161092

Info Message (12:47:00 pm) joins : 5637161117

Info Message (12:47:00 pm) exists joins : 5637161117

Info Message (12:47:00 pm) joins : 5637161116

Info Message (12:47:00 pm) exists joins : 5637161116

Info Message (12:47:00 pm) joins : 5637161095

Info Message (12:47:00 pm) exists joins : 5637161095

Info Message (12:47:00 pm) joins : 5637161093

Info Message (12:47:00 pm) exists joins : 5637161093

Info Message (12:47:00 pm) joins : 5637161098

Info Message (12:47:00 pm) exists joins : 5637161098

Info Message (12:47:00 pm) joins : 5637161099

Info Message (12:47:00 pm) exists joins : 5637161099

Info Message (12:47:00 pm) joins : 5637161115

Info Message (12:47:00 pm) exists joins : 5637161115

Info Message (12:47:00 pm) joins : 5637161100

Info Message (12:47:00 pm) exists joins : 5637161100

Info Message (12:47:00 pm) joins : 5637161101

Info Message (12:47:00 pm) exists joins : 5637161101

Was this reply helpful? Yes No

Join the conversation

Community site session details

what is different betwean joins and Exists joins in the D365FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

what is different betwean joins and Exists joins in the D365FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates