Types of joins

ACL supports six different types of joins:

Joins that include matched primary records also include the matching secondary records. Primary and secondary records are matched if they have identical values in the primary and secondary key fields. Primary or secondary records are unmatched if they do not have an identical value in the primary or secondary key fields.

The first five join types are many-to-one joins. The final type is a many-to-many join. ACL does not support one-to-many joins. The join type you choose determines which records are included in the joined table, as summarized below.

Table 1. Records included in joined table

Join type/

Join dialog box option

Matched primary records

Unmatched primary records

Matched secondary records

Unmatched secondary records

Matched primary records





Unmatched primary records



Matched and unmatched primary records







Matched primary records and unmatched secondary records







(includes duplicate occurrences of matching secondary key values)

Matched primary records and unmatched primary and secondary records









(includes duplicate occurrences of matching secondary key values)

Many-to-many matched records





(includes duplicate occurrences of matching secondary key values)

Related concepts
About joining tables
Examples of join types
Automatic harmonization when joining tables
Related tasks
Joining tables


(C) 2015 ACL Services Ltd. All Rights Reserved.