Inner Join in X++
Ø Select records from first table that have matching
record with join table.
Ø First table record and join table records are
joined together and show as single record.
Ø Records without related records in the jointable are
eliminated from the result
Outer
Join in X++
Ø Select
all the records from first table and related records from join table
Ø The
records are retrieved whether they have matching records in the joined table
Ø If
there is no match, the field from join table is empty
Exist
Join in X++
Ø Selecting
record from first table only if there is matching record in join table.
Ø It
will return only one table record, not a related table record.
NotExist Join in X++
Ø Select records from the first table that do not have a
match in the joined table