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.
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.