15.10 - Inclusion Join - Teradata Database

An inclusion join is a product, merge, or hash join where the first right table row that matches the left row is joined.

There are three types of inclusion join.

Inclusion merge join

Inclusion product join

Inclusion hash join

Also see “Inclusion and Exclusion Product Joins With Dynamic Row Partition Elimination” on page 468.

1 Read each row from the left table.

2 Join each left table row with the first right table row having the same hash value.

1 For each left table row read all right table rows from the beginning until one is found that can be joined with it.

2 Return the left row if a matching right row is found for it.