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.
