web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / what is different betw...
Finance | Project Operations, Human Resources, ...
Answered

what is different betwean joins and Exists joins in the D365FO

(0) ShareShare
ReportReport
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)
  • WaytoAx Profile Picture
    WaytoAx 130 on at
    RE: what is different betwean joins and Exists joins in the D365FO

    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

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: what is different betwean joins and Exists joins in the D365FO

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

  • WaytoAx Profile Picture
    WaytoAx 130 on at
    RE: what is different betwean joins and Exists joins in the D365FO

    Many thanks Andre Sir.

  • WaytoAx Profile Picture
    WaytoAx 130 on at
    RE: what is different betwean joins and Exists joins in the D365FO

    many thanks quickly replay Nikolaos,

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

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,366 Super User 2025 Season 2 on at
    RE: what is different betwean joins and Exists joins in the D365FO

    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.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: what is different betwean joins and Exists joins in the D365FO

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

    Normal join will.

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,140

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 762 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 706 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans