I. Objectified foreign key

1. Transform foreign key values to records in referenced table

2. Retain nonmatched records only

II. Normal joins

1. Using hashing algorithm

2. Using order-based merge

3. Foreign key joins

4. Cross product

5. Joining files

III. Position-based Joins

1. Location by sequence numbers

2. Location by value positions

3. Location by field positions

IV. A join with sequence

1. Left join

2. Degenerate to cross product

3. Complicated joins

Click to download the PDF file