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,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

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... 303,669 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Many thanks Andre Sir.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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