Joins In AX

Main table records => 3

Child table records => 3

Matched reocords in child table => 3 (2 duplicate and 1 is unique)

Inner join => matched records in Parent table (P => 3, C => 3)

Outer Join => Matched records in Parent table and Unmatched records display in parent datasource only, show null values in child datasource unmatched records.

Exists Join => display matched records in parent table in child datasource shows null values.

Not Exists Join => display only in parent table records those are not existing in the child table.