D365 Joins

Dynamics 365 ERP - Development

Inner Join is the default join in Dynamics 365 Finance and Operations and returns records only when there is a match in both tables.
Outer Join retrieves all records from the primary table, even if no matching records are found in the secondary table.
Exists Join checks for the presence of matching records in the secondary table without returning data from it.
NotExists Join pulls data from the primary table where no matching records exist in the related table.
Inner Join example: Displays common records between two tables.
Outer Join example: Shows all records from the primary table and common records from the secondary table.
Exists Join example: Demonstrates common records from the primary table.
NotExists Join example: Exhibits records from the primary table where no matching records exist.

Registered users can view the full text for FREE!